Search results

I tried your suggestion, too JANR. I am getting the same error. And the Macro does know what "[Combo10].[Column](1)" is. I can display a message with it's value. I just can't use it to set a field's value for some reason :(

Unfortunately that did not work, I'm still receiving the same error. These Macros are giving me a head ache.

I tried it and I got the same results. [RecordID]= (any number) works and =[Combo10].[Column](1) works I don't see why [RecordID]=[Combo10].[Column](1) doesn't work. It is quite frustrating.

Hmm, idk about the full reference because each side of the equation works separately, they just don't work together.

Hey guys I'm working on one of my first macros. I am using this macro to open up another form and display a specific record. The record to go to is determined by a combo box. I am using the open form command with the form name, and then the where clause to open the specific record within that...