Combo and Sub Form (1 Viewer)

JPR

Registered User.
Local time
Today, 02:06
Joined
Jan 23, 2009
Messages
192
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

Enthusiastic Amateur
Local time
Today, 09:06
Joined
Sep 21, 2011
Messages
14,037
You would need to include the Form name as well. Use the builder to get the correct syntax.
 

mike60smart

Registered User.
Local time
Today, 09:06
Joined
Aug 6, 2017
Messages
1,899
Hi
Can you upload a zipped copy of the database?
 

JPR

Registered User.
Local time
Today, 02:06
Joined
Jan 23, 2009
Messages
192
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.
 

Users who are viewing this thread

Top Bottom