Method or Data Member Not Found

[Danu]

In the Forms Forum, I asked for help in setting up a form which would filter
records from a table. The following web site was suggested:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm. I went there and
downloaded the zip file. I reviewed the code and I am VERY NEW at
reading/writing code. I plugged it into my form and made changes where I
thought.

My form has two option groups and two combo boxes. When I try to compile the
SQL string via DEBUG/COMPILE in the VBA screen, I get an error message
"Method or Data Member Not Found" and it is highlighting "Select Case
Me.fraPNB.Value".

Here is my first question. fraPNB is referring to an option group on the
form. What is the method or data member not found?

Thanks in advance for any help.

 

[UpRider]

Do you have a subform on the main form?
Can you post the entire sub or function that the Select Case is in?

UpRider

 

[Ken Snell \(MVP\)]

That error that you see is saying that the compiler cannot "see" a control
named fraPNB that has a Value property. This can occur when you're editing a
form and compiling the code as you go; sometimes, the VBE compiler gets lost
and isn't seeing the form correctly.

Try closing the database, then reopening it and trying the code again. If
that doesn't work, try a compact and repair on the file.