Copying a autonumber into another field

[John11]

Hello

I am having a problem with my frmAddCustomer. I need it so when a new record is entered into tblCustomer (via the form) the autonumber made in CustomerID will be copied and entered into tblDelivery.CutomerID. Thus making a new record in tblDelivery. The form uses a query will all tblCustomer fields and tblDelivery's CustomerID.

How do i go about making it so when a new record from tblCustomers, the autonumber generated is automatically entered into CustomerID of tblDelivery (leaving other fields in tblDelivery empty ready to be edited at a later date)(also how do i make it so when I open up frmAddCustomer it goes straight to a blank record instead of viewing already entered customers)

Thanks

 

[astarbyfar]

Data entry

Not really sure about the first question il have a think about it but the answer to your second one is to create a new form and in the Form properties set the Data Entry to Yes. This will allow you to enter details without previous records being illustrated. I'll have a look through a couple of my books for the first question!

 

[John11]

Thanks astarbyfar, nearly completed the form now, just the same problem to get around still

Pat Hartman I cannot add the records to tblDelivery when ready to enter info into the other fields there because I have a query running where it shows some tblCustomer fields and some tblDelivery fields, the query can only shows those records that are in both the tables.