Form that allows for new input and search

[gtimmies]

Hi all,

I would like to create a form that pulls out the record if the customer number entered exists and creates a new record if the customer number entered does not exist. I was wondering if this is possible. If yes, how would I go about creating this?

Thank you in advance for your help.

 

[MStef]

Look at "DemoNewRecA2000.mdb" (attachment,zip).
Open "frmCustomer" and try.

 

[MStef]

If you want to improve, make a change in
"Sub Combo34_NotInList"
After
Me.CustNumber.SetFocus
add
Me.CustNumber = NewData
In that case you don't need to repeat a custom number.