H
hsdaguilar
Hello.
I have a form (Primary) with two subforms (Projects and Entitlements). I
have created a seperate unbound form (Query) with an option group (Select)
with three options (Location, Keyword, Entitlement). Location is a field in
the Primary form, Keyword is a field in the Projects subform and Entitlement
is a field in the Entitlements form. I would like to be able to select an
option, enter the information in an unbound textbox and click ok. Then
depending on the what option was selected the Primary form is opened to the
matching record.
I was thinking of using 3 queries and setting the criteria to the unbound
textbox in the Query form, then setting up a select case with an open form
for each. I'm not exatcly sure how to go about this. Any help would be
appreciated. Thx.
I have a form (Primary) with two subforms (Projects and Entitlements). I
have created a seperate unbound form (Query) with an option group (Select)
with three options (Location, Keyword, Entitlement). Location is a field in
the Primary form, Keyword is a field in the Projects subform and Entitlement
is a field in the Entitlements form. I would like to be able to select an
option, enter the information in an unbound textbox and click ok. Then
depending on the what option was selected the Primary form is opened to the
matching record.
I was thinking of using 3 queries and setting the criteria to the unbound
textbox in the Query form, then setting up a select case with an open form
for each. I'm not exatcly sure how to go about this. Any help would be
appreciated. Thx.