Running Query filtered by Form data

  • Thread starter Thread starter Flannel
  • Start date Start date
F

Flannel

I recently upgraded from Access 2000 to 2003 and some
things broke in one of my programs. I would be surprised
if 2003 can't do this. Not sure if I need to do it a
different way, or if he really should still work.

I have a query where one of the fields criteria is set to
a text box on a subform. example:

Forms!MainForm!SubForm!txtContactID

I have the form open, I can see that the txtContactID
field is correct, but when I run the query it opens with
no records. If I move the txtContactID box to the main
form it works fine (Forms!MainForm!txtContactID). Again,
this worked in 2000. Any help or information on this would
be apprectiated. I will also post another question in a
seperate message that is related to subforms.

Thank You
 
I have a query where one of the fields criteria is set to
a text box on a subform. example:

Forms!MainForm!SubForm!txtContactID
Click to expand...

Try changing this reference to

Forms!MainForm!SubForm.Form!txtContactID
 
Back
Top