G
Guest
I have two forms.
1. Query form- has two fields, address and street.
2. Primary form- has many fields, including an address and street field.
I currently use the Query form to query the Primary form. If there is a
match it opens to that record. If there is no match, it gives the user a
message, "there is not match, would you like to add a new record?" with yes
and no buttons.
What I would like it to do is -if there is no match- copy the text/value
entered in the Query form and paste it in the corresponding fields in the
Primary form after the person clicks yes on the message box.
Your assistance is greatly appreciated.
1. Query form- has two fields, address and street.
2. Primary form- has many fields, including an address and street field.
I currently use the Query form to query the Primary form. If there is a
match it opens to that record. If there is no match, it gives the user a
message, "there is not match, would you like to add a new record?" with yes
and no buttons.
What I would like it to do is -if there is no match- copy the text/value
entered in the Query form and paste it in the corresponding fields in the
Primary form after the person clicks yes on the message box.
Your assistance is greatly appreciated.