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
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