Query Form in Tab Control

[tomyplystation]

I have created a form in a tab control and it is on tab page 0. The tab control is on a form. When I run a qyery against the form on the tab I get 0 results. The query should be returning one line of data. In the query criteria I have [Forms]![Request_Form]![txtAuthID]. The main form is Member_Form with the tab control as TabCtl103 and the subform as Request_Form. Any help would be great.

 

[TheAceMan1]

How are ya tomyplystation . . .

and this:

[blue][Forms]![Member_Form]![Request_Form].Form![txtAuthID][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[LisaWay]

TheAceMan1,

I think you have an extra "form" in your expression. Please try:

[Forms]![Member_Form]![Request_Form]![txtAuthID]

Regards,
Lisa

 

[tomyplystation]

TheAceMan1,
Thank you. That worked.

Tomyplystation

 

[TheAceMan1]

tomyplystation . . .

Its a matter of proper form referencing. See: Refer to Form and Subform properties and controls

BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]