nevermind, somehow I got it to work
HOWEVER... there is one simple syntax that I am messing up on. I put
[Forms]![this is where I put the name of my form]![cboDiagnosis]
in the criteria section of the Query Builder grid and it works fine if I ONLY open up that one form [Diagnosis], BUT the form where the combo boxes are in [Diagnosis] will actually be a subform in another bigger form [frmMain]. Everytime I open up [frmMain], I get a
"Enter Parameter Value for [Forms]![Diagnosis]![cboDiagnosis], popup".
How would I write the syntax to make it function properly.
This is where I received the example..
http://office.microsoft.com/en-us/access/HA011730581033.aspx
Thanks in advance.

[Forms]![this is where I put the name of my form]![cboDiagnosis]
in the criteria section of the Query Builder grid and it works fine if I ONLY open up that one form [Diagnosis], BUT the form where the combo boxes are in [Diagnosis] will actually be a subform in another bigger form [frmMain]. Everytime I open up [frmMain], I get a
"Enter Parameter Value for [Forms]![Diagnosis]![cboDiagnosis], popup".
How would I write the syntax to make it function properly.
This is where I received the example..
http://office.microsoft.com/en-us/access/HA011730581033.aspx
Thanks in advance.
Last edited: