S
Sandra Grawunder
I have a few problems with a form.
1. I have a combobox GetName to select a name from a
list. The PK is PPID. If the name doesn't exist I have a
proc to open the contact list tblPeople to enter the new
information. I have a subform frmMasterList based on a
query of this table to fill in the rest of the address,
etc. but this subform does not link to the correct
information of the PPID for the new entry. Instead it is
still showing the information for the previous record.
If I move out of this new record then back in the
information is correct. How do I get this to link
correctly?
2. My form for tblPeople consists of a main form and a
subform. The main form contains basic information about
a master record. The subform is for a table that
contains multiple contacts for this master record. The
master record has a field NameID. I would like to pass
the value of NameID as a default value (which can be
changed if required) to a LastName field in the subform
table. How do I accomplish this?
1. I have a combobox GetName to select a name from a
list. The PK is PPID. If the name doesn't exist I have a
proc to open the contact list tblPeople to enter the new
information. I have a subform frmMasterList based on a
query of this table to fill in the rest of the address,
etc. but this subform does not link to the correct
information of the PPID for the new entry. Instead it is
still showing the information for the previous record.
If I move out of this new record then back in the
information is correct. How do I get this to link
correctly?
2. My form for tblPeople consists of a main form and a
subform. The main form contains basic information about
a master record. The subform is for a table that
contains multiple contacts for this master record. The
master record has a field NameID. I would like to pass
the value of NameID as a default value (which can be
changed if required) to a LastName field in the subform
table. How do I accomplish this?