It has been a while...

[SOS]

Okay, we had the Bangs and dots in the wrong places. Try this instead:

[Forms]![ref_form]![ref_history_subform].[Form]![USER]

 

[aftershokk]

thanks so much
I new it was a syntax thing but it has been 7 years since I did any of this stuff.

thx!

 

[SOS]

Yeah, tracking it down can be a real pain. I just used this method to make sure the syntax was right.

 

[vbaInet]

Just thought I should drop by and give you this link on referencing too. Might help in the future:

http://www.mvps.org/access/forms/frm0031.htm