Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Missing operator error

Status
Not open for further replies.

FunGuy

MIS
Sep 15, 1999
36
US
When I do an DoCmd.OpenForm in a command button, I get a missing operator error in the criteria. Seems obvious to me there is no missing operator in the criteria I use: DoCmd.OpenForm "frm3Info",,,"[OrgID]=" & Me![OrgID]

I use similar statements in other forms that work fine. The only big difference I can see is that this particular DoCmd is in a For Each loop with an embedded If...Then that goes thru the forms collection. Any ideas why Access thinks this is missing an operator when in other forms it works fine?
 
Whoops. Never mind. The problem is that I changed the source of a field on the subform. When I set it to the right table, everything worked fine.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top