taholmes160
New member
- Local time
- Yesterday, 23:51
- Joined
- Feb 14, 2019
- Messages
- 2
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
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