S
Shadow
Using Access 2003 & have form\subform. I am trying to eliminate entering a
duplicate record. Researched this discussion group and have lots of ideas
and one partially works for me. When I find a duplicate, I answer No on the
message dialog box and a screen with my form and the data I have entered is
displayed.
I can manually close the open form on the screen via the Close button on the
form. This automatically opens my MainMenu. I can click on the correct
open form button on the MainMenu and proceed to find and open the record that
I was trying to duplicate.
I would like to automate this process to simplify the data input process. A
code statement will close the form and open MenuMain. When I add a code
statement to open the form, I get error 3008 "The table is already opened
exclusively by another user -----. How do I close the "open" table "tblInput"
so I can continue and finsh the correct record?
duplicate record. Researched this discussion group and have lots of ideas
and one partially works for me. When I find a duplicate, I answer No on the
message dialog box and a screen with my form and the data I have entered is
displayed.
I can manually close the open form on the screen via the Close button on the
form. This automatically opens my MainMenu. I can click on the correct
open form button on the MainMenu and proceed to find and open the record that
I was trying to duplicate.
I would like to automate this process to simplify the data input process. A
code statement will close the form and open MenuMain. When I add a code
statement to open the form, I get error 3008 "The table is already opened
exclusively by another user -----. How do I close the "open" table "tblInput"
so I can continue and finsh the correct record?