Automatically generate a new record

  • Thread starter Thread starter Crown Jenny
  • Start date Start date
C

Crown Jenny

Can I autumatically generate a new record adding information (future date)
from a current record?
 
Yes. In your form have Double-click event call an append query that pull
data from your form fields to append one record.

INSERT INTO [YourTableToAppendInto] ( Field1, Field2, Field3, Field4 )
SELECT TOP 1 [Forms]![YourForm]![1stField] AS [X],
[Forms]![YourForm]![2ndtField] AS [Y], [Forms]![YourForm]![2rdtField] AS [Z],
[Forms]![YourForm]![4thtField] AS [A];
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key cannot general a new number for the record 2
Add one year in second combobox in vba 0
AutoNumber automatically generate on New Record? 3
Autopopulate a Field in a New Record Based on a Field in a Prev Re 1
Default Values for a field 7
Last record plus 1 1
want to automatically generate records 2
How to generate records from an existing table with dates 2

Back
Top