Sean Milligan
New member
- Local time
- Today, 03:06
- Joined
- May 21, 2021
- Messages
- 1
Hello!
I have a form which is linked to a simple select query with the Where criteria is link to a drop down box which the users can see and select one of 15 options.
Within the form there is a sub form. linked to another Simple select query with the Were criteria is linked to the same drop down box as above. This works find and I am.
The Variable linked with the drop down box is called CboDashDiv
Everything work find and I'm getting all the information I need to appear in both froms.
The user has the ability to reselect different options and the data is refreshed. This is used by the after update, is re runs the 2 queries. In VBA
My issue is when I got to exit the form, I'm prompted twice to input the CboDashDiv parameter. Its like its trying to re-run the quire even though I've quit the form.
any suggestions of why I may be getting the prompted, even though I'm quitting the form?
I have a form which is linked to a simple select query with the Where criteria is link to a drop down box which the users can see and select one of 15 options.
Within the form there is a sub form. linked to another Simple select query with the Were criteria is linked to the same drop down box as above. This works find and I am.
The Variable linked with the drop down box is called CboDashDiv
Everything work find and I'm getting all the information I need to appear in both froms.
The user has the ability to reselect different options and the data is refreshed. This is used by the after update, is re runs the 2 queries. In VBA
My issue is when I got to exit the form, I'm prompted twice to input the CboDashDiv parameter. Its like its trying to re-run the quire even though I've quit the form.
any suggestions of why I may be getting the prompted, even though I'm quitting the form?