Adding a record code doesnt work!!!

[nish2009i]

Hi, i have designed a booking form.. when the user wants to make a new booking they can either choose from existing list of customers from a combo box or ADD NEW CUSTOMER using following button of which the code is:


DoCmd.OpenForm "frmAddCustomer", acNormal, "", "", , acNormal
DoCmd.GoToRecord , "", acNewRec


as can be seen, this opens my AddNewCustomer form, however, i need a code for SAVE button for this form which would add a new customer to the CUSTOMER table. i dont know how to do because i need it to check that the fields are not left empty and most importantly, i need it to SAVE in the database and i cannot make it work!!! HELP!

 

[pbaldy]

The simplest solution would simply be to make the customer table the record source of that form.

 

[nish2009i]

yaa.. i figured it out now and its working! thanks