M
miss031
I have a form, "add/edit contacts". In this form, I have a sub-form at the
top with a search combo, so the user types in either the last name, company
name or phone number into the combo, clicks the search button, and the
similar records turn up on the subform.
Now, I would like for there to be a command button that makes the selected
record on the subform (when clicked) to be the current record on the main
form, which has other subforms for updating the contacts other types of
information (address, alt.numbers, etc.).
To clarify: if 4 records turn up, the user clicks on one of them,then on the
"Edit" button, and the selected contact is the current record on the main
form. Is this something I can do? And if so, is it recommended?
Also, I would like to have in the header of the subform, a count of the
records resulted (ex. "4 Matches"). How do I do this?
top with a search combo, so the user types in either the last name, company
name or phone number into the combo, clicks the search button, and the
similar records turn up on the subform.
Now, I would like for there to be a command button that makes the selected
record on the subform (when clicked) to be the current record on the main
form, which has other subforms for updating the contacts other types of
information (address, alt.numbers, etc.).
To clarify: if 4 records turn up, the user clicks on one of them,then on the
"Edit" button, and the selected contact is the current record on the main
form. Is this something I can do? And if so, is it recommended?
Also, I would like to have in the header of the subform, a count of the
records resulted (ex. "4 Matches"). How do I do this?