Creating an Add/Edit record Form (1 Viewer)

Hi Folks:

Please note this thread is cross posted at 2 other forums, accessforums dot net and utteraccess dot com

I have a form that I have created that I am trying to make into an add/edit record form. Its a basic form that has a button for add a new record on it. Works fine for editing forms, paging through them and stuff like that, but it REALLY doesnt like it when I try to add a blank record and fill it out. When I try to start filling out the form, it accepts the first value just fine, but when I try to put the next one in, I get the following message;

The value can not be added to this new row until the row has been committed. Commit the row first and then try adding the value

View attachment SLRG_Waybills_4 -- to post 2-11-2019.zip

This is a zipped copy of the database, the form you are looking for is frmCarManagement

On the accessforums.net forum, I received the following response

Turn the wizard on, add a button,
select the ADD NEW RECORD button from the list,
the code should save the record before creating the new rec.
if not, put the save rec code right before the New rec code.

Here is a zip of a screenshot of the macro in question

View attachment Macro.zip

Any help you can give, I'd appreciate

TIM

Just giving this a bump as its had no responses here.
If you now have an answer, please mark it solved.
Otherwise, please provide links to the threads at the other two forums

Hi

I changed the relationship between tblCars and tblCarCodes.

The Form now allows you to add a New Record

View attachment SLRG_Waybills_4 -- to post 2-11-2019.zip