Automatically generate a new record

C

Crown Jenny

Can I autumatically generate a new record adding information (future date)
from a current record?
 
K

KARL DEWEY

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];
 
Top