Creating an Add/Edit record Form

[taholmes160]

Hi Folks:



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


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

This is the database zipped and attached, the form you are looking for is frmCarManagement

Thanks
TIM

[ranman256]

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.

[taholmes160]

Hi Ranman256 -- I added the button using the wizard
heres a screenshot of the macro on that button



Tim

[taholmes160]

Please note:

Due to limited responses here, I have cross posted this topic a the following location(s)

https://www.utteraccess.com/forum/in...wtopic=2052625
https://www.access-programmers.co.uk...isplay.php?f=9 - note cannot give the exact link as the post has not yet received approval

[June7]

Recommend not include TblCarCodes table in RecordSource. But if you do, use LEFT instead of INNER join. I changed this and not getting described issue.

Just bind to TblCars. Expression in textbox can reference column of combobox to display the CarType description.
=[AARCode].Column(2)

Either way, textbox displaying CarType description from TblCarCodes should be Locked Yes and TabStop No.

[taholmes160]

Hey June 7

Thanks for the fix, it worked a treat

TIM