O
ocm
Greetings,
I have a main form (frmHouseHold) and a subform (sfrmApplicants). In
both forms I have a field called Social Security Number (HouseHold’s
SS#) and (Aplicant’s SS#).
I was trying to create a search capability, whereby when a user clicks
a button will return the value from both main & subform. For instance,
the user is looking SS# 123-45-6789 and doesn’t know if it’s a
HouseHold or an Applicant, then the user will click a button to search
throughout the database (both main form and subform) and returns the
value.
Thank you in advance!
OCM
I have a main form (frmHouseHold) and a subform (sfrmApplicants). In
both forms I have a field called Social Security Number (HouseHold’s
SS#) and (Aplicant’s SS#).
I was trying to create a search capability, whereby when a user clicks
a button will return the value from both main & subform. For instance,
the user is looking SS# 123-45-6789 and doesn’t know if it’s a
HouseHold or an Applicant, then the user will click a button to search
throughout the database (both main form and subform) and returns the
value.
Thank you in advance!
OCM