Search or Find current customers

[rizzir]

Hi,
I have 3 tables
Customers
Tranasaction
Items

Linked togather, working fine.

Now I have setup one form where i enter each transaction details

Item details, customer details and transaction details

I would like create customer find function, which will check current records for that customer account no, if customer account does not exist then form will let me create a new customer.

can anyone please tell me how can i do that . thanks
I tried using combo box, but shows me record but does not let me enter new customer account no.

thanks in advance : )

 

[RuralGuy]

The ComboBox is the usual method of achieving your goal. Is your cbo unbound and are you "finding a record..."? Are you taking full advantage of the NotInList event? Mastering the Combo Box NotInList Event