M
magmike
I am trying to take my main form (Prospects) and update the
corresponding fields from a subform (where the corresponding field's
radio box is selected - Field: Name, Radio Box: Name_Select).
The subform's record source is a query based on a completely different
table from the main forms record source (Prospects - tabled name the
same as form), and there is not a linkable field, such as an ID code.
The subform has a combo box that allows me to type in a company name
and then display the corresponding company's record in the form (the
subform of the main form). I then want to be able to update the
Prospect form's current record in its table (prospect table) with the
corresponding fields in the subforms current record. What would the
code for this command button look like?
Thanks in advance!
magmike
corresponding fields from a subform (where the corresponding field's
radio box is selected - Field: Name, Radio Box: Name_Select).
The subform's record source is a query based on a completely different
table from the main forms record source (Prospects - tabled name the
same as form), and there is not a linkable field, such as an ID code.
The subform has a combo box that allows me to type in a company name
and then display the corresponding company's record in the form (the
subform of the main form). I then want to be able to update the
Prospect form's current record in its table (prospect table) with the
corresponding fields in the subforms current record. What would the
code for this command button look like?
Thanks in advance!
magmike