I want to find a record in a subform via texbox and button. The search box is working fine on main form via macro on the button but i am unable to set cotrols to find data on the subform
the macro
what should be the reference to search in the subform? Subform name is "Client"
thanks in advance
the macro
Code:
="Passport_Number= '" & [Forms]![Agent]![sect] & "'"
what should be the reference to search in the subform? Subform name is "Client"
thanks in advance