Hi Experts,
I'm in need some help. I have 2 forms. Main form bound, pop-up form unbound. I need to be able to change and save data on the main form using the pop-up form.
Using a refresh command to the main form will eliminate the write conflict error but causes a different error because my the refresh command triggers some other code so i cant use that.
Here's what happening...
. I've also tried
to no avail.
any help is appreciated
I'm in need some help. I have 2 forms. Main form bound, pop-up form unbound. I need to be able to change and save data on the main form using the pop-up form.
Using a refresh command to the main form will eliminate the write conflict error but causes a different error because my the refresh command triggers some other code so i cant use that.
Here's what happening...
- Pop up form makes changes to record on main form using a submit button
- if code fails for any reason go to error handler
- error handler undos/reverse the changes made to the data via
Code:
Forms!MainForm!field = ""
- write conflict error occurs
Code:
Forms!Mainform!Form.refresh
Code:
Forms!MainForm.Dirty = False
any help is appreciated