Run Time error 380 could not set the Value property

[mmikem]

I have traced this problem to the combo box on my edit form. If I add the name on the line I want to edit to the member data base the edit form works, If the name is NOT in the data base I get the run time error
What I need to happen is if the name is not in the sheet (Membership ) then a dialog box pops up with a statement “Not a Active Member” when you click ok the the edit form opens with just the line Information
Iam not sure where or what I need to do So any HELP Please

Please Login or Register  to view this content.

[BadlySpelledBuoy]

When the runtime error pops up and that line is highlighted, can you press F8 and get past it?

If so, keep pressing it until it stops again (perhaps in the EditForm1 initialize event?) and then show us that sub and which line it stops on.

BSB

[mmikem]

it stops on the cboMem the combo box that looks at the line I am editing, the combo box also looks at the member data base for the name
see the code above marked cboMem

[rorya]

What code do you have in the Initialize and/or Activate events of the userform?

[mmikem]

here is the user form Initialize code

Please Login or Register  to view this content.

[mmikem]

When I do the F8 it stops at .cbomem.value under the section private sub userform intialize

[rorya]

Is your combobox's limittolist property set to true?

[mmikem]

Hi rorya
Not sure where you mean limittolist property set to true
I have looked at the property box for the combo box I do not see anything with limit to list same as my code