Help with form

mistaking

Registered User.
Local time
Today, 21:37
Joined
Apr 16, 2002
Messages
16
Further to my earlier post, this is what I am trying to do.
I have created a table where a customer record can be created, a customer ID is assigned via autonumber.
Now on a seperate form, i want to be able to enter either the customer id or name and press search and the relevent details come up. How do i go about this as when i put the controls on the form the customer ID is an autonumber and therefore i cant enter in that field.
 
Jack is right in the previous answer. The combo box will only show the customer names but will 'secretly' use the id number to find the record of the name selected. You actually will have 2 columns in the combo box - 1 is the ID (but set to zero length) and the other is the name which you see.

Col
 
Why is when i add the combo box, if i enter an invalid customer ID a record is still retrieved, am i doing something wrong or do i need to change something??
 

Users who are viewing this thread

Back
Top Bottom