Hi Guys I have problem. Actually I have many problems but only one that is attributable to Access Forms.
I have a form (Client) that houses a subform (Deals). I want the form to open based on a string criteria for a client and a particular deal.
IE. (Client_ID = 250, deal_id = 543). I am able to get the right client but cannot get it to open to the correct deal. This client has 7 deals.
I tried setting up a the following in the Form_OPen event.
If gFilterForm Then
Me!DEALID = gDeal_Id
End If
gFilterForm: a switch set in a Module
gDeal_ID: global field, value set in the same Module
Thanks
Trudye
I have a form (Client) that houses a subform (Deals). I want the form to open based on a string criteria for a client and a particular deal.
IE. (Client_ID = 250, deal_id = 543). I am able to get the right client but cannot get it to open to the correct deal. This client has 7 deals.
I tried setting up a the following in the Form_OPen event.
If gFilterForm Then
Me!DEALID = gDeal_Id
End If
gFilterForm: a switch set in a Module
gDeal_ID: global field, value set in the same Module
Thanks
Trudye