T
Tom
The following are some form properties and event sequences:
Properties:
a. Form_X: Modal property = Yes
b. Form_X has ListBox_Y
c. ListBox_Y calls both reports and queries
Sequence:
d. I click on ListBox_Y, Option1. This open a report.
e. When the report is opened, I set the following in the form:
"Me.Form.Visible = False". This allows me to bring up the report in front
of the form with its modal property=yes.
f. When report is closed, the report's OnClose event executes:
DoCmd.OpenForm "Form_X"
Based on steps a:f, I am able to utilize the modal property and "hide" the
form when a report opens and "unhide" the
form when the report closes...
Now, based on step c) I also have an option in the listbox that allows me to
open a query. However, the closing of the query doesn't allow me to call theswitchboard) disappears.
The benefit of using the query was the following command:
DoCmd.OpenQuery "Query_Z", acViewNormal, acReadOnly
This allowed me to not modify any data in the query.
I then attempted to just create another form that is linked to "Query_Z" and
show the form in datasheet view.
Using the form though results in yet in another problem. When I open the
table once... it works fine. However clicking on the listbox a second time
tells me that the table is locked.
My questions are:
1. given the original process (a:f), is there a way to open the Form_X once
I close the query?
2. if #1 is not possible, how can I make sure that if a table is open (being
viewed by a user), another user can enter data into the same table?
Tom
Properties:
a. Form_X: Modal property = Yes
b. Form_X has ListBox_Y
c. ListBox_Y calls both reports and queries
Sequence:
d. I click on ListBox_Y, Option1. This open a report.
e. When the report is opened, I set the following in the form:
"Me.Form.Visible = False". This allows me to bring up the report in front
of the form with its modal property=yes.
f. When report is closed, the report's OnClose event executes:
DoCmd.OpenForm "Form_X"
Based on steps a:f, I am able to utilize the modal property and "hide" the
form when a report opens and "unhide" the
form when the report closes...
Now, based on step c) I also have an option in the listbox that allows me to
open a query. However, the closing of the query doesn't allow me to call theswitchboard) disappears.
The benefit of using the query was the following command:
DoCmd.OpenQuery "Query_Z", acViewNormal, acReadOnly
This allowed me to not modify any data in the query.
I then attempted to just create another form that is linked to "Query_Z" and
show the form in datasheet view.
Using the form though results in yet in another problem. When I open the
table once... it works fine. However clicking on the listbox a second time
tells me that the table is locked.
My questions are:
1. given the original process (a:f), is there a way to open the Form_X once
I close the query?
2. if #1 is not possible, how can I make sure that if a table is open (being
viewed by a user), another user can enter data into the same table?
Tom
