Method or Data Member Not Found

[Pendragon]

Access03/WinXP

In what should be a very basic reference, I am getting an error "Method or
Data Member Not Found" in the following code. I'm guessing form corruption?

If Me.cboRollUpType = 1 And Me.txtMGR1 <> "" Then
resp = MsgBox("A MGR1 participant is already assigned. Do you want to
update with your selection?", vbYesNo)

The code fails on "Me.cboRollUpType". The combo box is indeed named
cboRollUpType. Even if I delete the reference in the code and start typing
"Me.", after I type the period I can select "cboRollUpType". The code still
fails. A compile fails here as well.

Suggestions?

Thanks!

 

[AccessVandal via AccessMonster.com]

Could be, but have you tried Compact and Repair yet? I'm not sure it will
prompt a error an message.

And is Access2003 updated to SP3?

 

[Gina Whipp]

Pendragon,

Where is the rest of the code? The part the defines *resp*. Error messages
sometimes point to lines that do not reflect where the actual error is.

Also, is cboRollUpType numeric or text? If text then the 1 should be "1".
I would also confirm txtMGR1, does that come up when you type Me.?

If Me.cboRollUpType = 1 And Me.txtMGR1 <> "" Then
resp = MsgBox("A MGR1 participant is already assigned. Do you want to
update with your selection?", vbYesNo)


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Pendragon]

Apparently in doing some modification the text box txtMGR1 had been renamed
to simply txtMGR and I didn't catch it. Thanks to both for the good
suggestions.

 

[Gina Whipp]

Pendragon,

I hate it when that happens... <smile>

You're welcome!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm