Combo and Sub Form

[JPR]

Hello,
I have created a form on which I have placed a tab control with two pages.
On page1, I have a combo with its record source from a table (tblState) and a subform (SubState) with its record source from a query (based on the same tblSate).

On the same page1 I have placed a textbox that shows the selection from my combo - mytxt = combo.column(0) set as visible NO.
I would like that users select a State from the combo and all info related to that State show up in the SubState.

I have placed the following criteria in the query field State [mytxt] and in the combo After Update the code Me.SubState.requery but it's not working.

I appreciate any help with this problem. Thank you

 

[Gasman]

You would need to include the Form name as well. Use the builder to get the correct syntax.

 

[mike60smart]

Hi
Can you upload a zipped copy of the database?

 

[JPR]

Thank you. I think I have been able to sort the problem simply creating again the form and adding the combo. A nice macro in the after update event makes the record set change based on the selection in the combo.
Thank you for your assistance and time.