T
TomC
I have a main form (Client) and a subform (Activity). I am trying to work a
Combo Box on Last Name to bring up a list of Last and First Names before I
key a new record to either update a record already in the file or add the new
record.
I dragged Last Name as a Combo Box to the Form Header. The properties of
the unbound field has Client ID (Auto Number) in the Name with no control
source. The Row Source in the unbound field is Client ID, Client Last Name,
Client First Name and no other fields. When I click on a name, the subform
data is accuractly displayed in the subform, but the data for the main form
is not displayed. How do I get the main form data to display so that I can
update it along with the subform data?
I would greatly appreciate any help you could give me on this.
Combo Box on Last Name to bring up a list of Last and First Names before I
key a new record to either update a record already in the file or add the new
record.
I dragged Last Name as a Combo Box to the Form Header. The properties of
the unbound field has Client ID (Auto Number) in the Name with no control
source. The Row Source in the unbound field is Client ID, Client Last Name,
Client First Name and no other fields. When I click on a name, the subform
data is accuractly displayed in the subform, but the data for the main form
is not displayed. How do I get the main form data to display so that I can
update it along with the subform data?
I would greatly appreciate any help you could give me on this.