Avatar of Michael
Michael
Flag for Australia

asked on 

Save button over-writing first record every time

Hi Folks
I have two questions to help me over the current hump please.
I have put together a training database using a tabbed form with Personal Details on the first form and Training Details on the second form.
I have a number of tables that populate combo boxes, one table for Personal Details and one for Training Details.  The save button saves to both forms though it only saves to the first record.  It also does not go to new blank record in the form.

I have also used a query to calculate retraining due from the training date and the length of time required for the retraining.  I would like the Due Date in the query to populate the text box Due date in the form as the retraining period is entered, is this possible.

I plan to have a number of queries and reports available for users once I have the database working correctly.

Your assistance would be greatly appreciated.

Cheers

PPS-Employee-Training.accdb
Microsoft Access

Avatar of undefined
Last Comment
Michael

8/22/2022 - Mon