Tabbed page reference

[romeerome368]

Hello All,

I have a tabbed form, and there is a combo box on Page1 using Access 2007. I want this combo box to be a filter for a query and return data to a list box on Page1, but my reference to my combo box is not working.

I'm not quite sure how the syntax needs to be entered in the criteria area of the query.

For a normal form, the syntax would be [Forms]![formname]![control], but I'm not sure about tabbed forms.

HELP please!!!!

Any help is greatly appreciated.

 

[dhookom]

The syntax is the same. You don't need to worry about the tab control name.

Duane
Hook'D on Access
MS Access MVP

 

[romeerome368]

Hello Duane,

Thanks for solidifying that I'm not going crazy, but for some strange reason Access does not like the syntax. Below is the error message that I am getting when I try to run the query.

The Microsoft Access Database engines does not recognize [Forms]![frmDataSrch]![PC] as a valid field name or expression.

Is there a reference that I need to have selected for the syntax to be recognized by Access?

 

[romeerome368]

please forgive the smiley. It came up when I used the [ P C ] as my field name. I know that the brackets need to be there, but for this exercise in the forum, I am going to leave them off to eliminate the smiley.

Forms!frmDataSrch!PC

 

[dhookom]

Is the control named PC? Is this on the main form or a subform? Is the form open?

Duane
Hook'D on Access
MS Access MVP

 

[romeerome368]

Yes, Duane the control is named PC, and it is on the main form as a combo box. Not on an open form, and when the query is running the form is open.

That's why I'm so confused. I have been doing this for the past 12-15 years, and I know it should work. I'm thinking it's something different in Access 2007 that's causing this to happen. That's why I asked about references. Maybe I need to select a reference in order for it to be able to access the forms and the controls on them.

 

[romeerome368]

I meant to say that it wasn't on a subform, not "Not on an open form", but yes, the form is open when the query is running.

 

[boblarson]

Make sure that the bound field is the correct one you want and that matches up to the data.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[romeerome368]

Thanks Bob for your assistance as well.