compiler error

[Sheba]

Hi, I have this code for an options Group control I just created on my form but when I compile it, it tells me "Method or data member not found"
and it highlights the table field name.

The field exists in the table! Could someone please tell me what is wrong here? Many thanks in advance

If Me.NewRecord Then

Me.Frame1058 = Null

Else


Me.Frame1058 = Switch(Me.notcort = "Normotensive (MAP >= 65mmHg)", 1, Me.notcort = "Allergy", 2)

[June7]

Is this code behind a form? Is the field in the form's RecordSource?

[Sheba]

Hi June7, sorry the code is in the On_Current event of the form and the field is unbound...

[Sheba]

yes (if I understood you correctly) the field is in the table, which is the form's RecordSource

[June7]

Field is not unbound, a control can be unbound. If notcort is a field in RecordSource but not used as ControlSource, try using bang (!) instead of dot.

Me!notcort

Otherwise, bind a textbox to the field. Apparently, VBA is expecting to find a control because of the dot.

[Sheba]

I meant to say that the Control was unbound. I have over 30 option group controls in this form and each one has a similar line of code. However not all of them are flagged by this compiler error.

I could try that but if I'm supposed to have used me!* instead of me.* wouldn't it have complained about all the other field names in the code? Just brain storming here...

[Sheba]

I changed it to me!notcort but still get the compiler error

[June7]

True, I was grabbing straws. Don't know your form structure. Did you try binding a textbox to the field just to see if that helps? Are you sure about spelling?

The only other thought I have is corruption.

[Sheba]

the spelling is correct. it might be corruption and that is scary. I copied a form (in the same project) and spent two days modifying it. It will be terrible if I have to scrap it altogether

[Sheba]

I bound a text box to the field and it worked. I'll create new option group controls to replace the affected ones...
hopefully that'll fix em. Thanks June7.
I'll repost an update.

[June7]

Sometimes copying a form and deleting the old one will fix corruption but usually requires a new form object then try copy/paste all the controls from old. Sometimes just deleting and recreating problem controls will fix.

[Sheba]

Thanks June7 for your update. Sorry for my late response, I was away. I duplicated an old form and zapped all the controls on it. I then recreated each one (mind you, more than 30 of them) and added its code but I'm still getting the "Method or Data member not found" error for some of them. Please help

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[Sheba]

I want to copy the switchboard form and paste it in the version I'll upload but it is asking me to provide a password. I know the password but it is not giving me a textbox to input it How do I supply this password?

[June7]

Why is there a password? Where is code demanding password? Maybe not an issue if I can open db with shift key bypass. What form is the issue?