K
Kathy Ratermann
This is a re-post of my earlier question as I am still
having trouble. I have a main form called Case
Information. Within this main form, I have a subform
called Customer Names. Sometimes I have more than one
Customer Name for each record in the main form, which is
why I have the subform. The Customer Names subform has
the following fields: CaseInfoID (link to main form),
CustNameID (primary key), CaseNumber, CustLastName and
CustFirstName. When I open the main form, I want to be
able to search for a particular customer to see if they
already exist in my database. If the customer exists, I
want the main form to show that customer as the current
record. Sometimes, there may be more than one customer
with the same name, so I need a way to make a selection.
If the customer does not exist in my database, I want to
enter them as a new customer. Right now, I am using a pop-
up dialog box form. I enter the last name in the Dialog
Box and it returns in datasheet view all matches, showing
the following fields: CaseInfoID, CustLastName and
CustFirstName fields. Is there some code I can use so
that if I click on one of the records returned by the
search, the customer I clicked on will now be the current
record of the main form? Or any other suggestions for
accomplishing this task? Any help would be greatly
appreciated!!
having trouble. I have a main form called Case
Information. Within this main form, I have a subform
called Customer Names. Sometimes I have more than one
Customer Name for each record in the main form, which is
why I have the subform. The Customer Names subform has
the following fields: CaseInfoID (link to main form),
CustNameID (primary key), CaseNumber, CustLastName and
CustFirstName. When I open the main form, I want to be
able to search for a particular customer to see if they
already exist in my database. If the customer exists, I
want the main form to show that customer as the current
record. Sometimes, there may be more than one customer
with the same name, so I need a way to make a selection.
If the customer does not exist in my database, I want to
enter them as a new customer. Right now, I am using a pop-
up dialog box form. I enter the last name in the Dialog
Box and it returns in datasheet view all matches, showing
the following fields: CaseInfoID, CustLastName and
CustFirstName fields. Is there some code I can use so
that if I click on one of the records returned by the
search, the customer I clicked on will now be the current
record of the main form? Or any other suggestions for
accomplishing this task? Any help would be greatly
appreciated!!