Filtering a Form by way of a combo box on another form

[mjanalyst]

Bob. When I save the database it wont let me save it as a later version unfortunately. The form's record source that is being opened is called testing. Its a table that all my records are placed in. ESCO_Name is just one of the columns in that table.



That is the settings that I currently have for that form. Please let me know if you have any other questions. If I dont get back to tonight, I will respond tomorrow. Thanks.

MJ

 

[bob fitz]

I was asking about the settings of the controls (textboxes, combo boxes etc) on the second form.
Try this:
Create a new text box on the form that is being opened.
Set the textbox name property to ESCO_Name and set its Control Source property to ESCO_Name as well. Close and save changes. Then try opening it with the code as before.

 

[pbaldy]

As I mentioned, the parameter prompt is telling you the name is misspelled, and it does have a space, not an underscore.

DoCmd.OpenForm "Testing", , , "[ESCO Name] = """ & Me.Combo19.Column(1) & """"

 

[mjanalyst]

Great news guys it works now!!! pbaldy the code you gave did it for the parameter problem. Both thank you so much for the help. Greatly appreciated.

 

[pbaldy]

No problem.

 

[bob fitz]

Not sure that my comments were of much use, but I'm glad you've got it working.