MackMan
Registered User.
- Local time
- Today, 07:56
- Joined
- Nov 25, 2014
- Messages
- 174
Morning all.
I have a dilemma that's bugging me, and I can't seem to understand why it's doing this...
I have a query, and in order for it to run properly, I've set it to look in an unbound combobox on a form to display the necessary data I want, as long as I never close down the form, this is exactly how I want it.
However, if I close this form down, and reopen it, I'm asked by messagebox to get the lookup from a different form's combobox, despite saving the correct form's design over and over again, and saving the actual query, more than once, while in design view.
The thing that's really frustrating is, when Access changes the criteria, there isn't even a combobox value on the form it changes to.
Despite looking for almost two days on here and the internet, I'm still none the wiser, and what I can do to prevent this.
As always any help is greatly appreciated.
I have a dilemma that's bugging me, and I can't seem to understand why it's doing this...
I have a query, and in order for it to run properly, I've set it to look in an unbound combobox on a form to display the necessary data I want, as long as I never close down the form, this is exactly how I want it.
However, if I close this form down, and reopen it, I'm asked by messagebox to get the lookup from a different form's combobox, despite saving the correct form's design over and over again, and saving the actual query, more than once, while in design view.
The thing that's really frustrating is, when Access changes the criteria, there isn't even a combobox value on the form it changes to.
Despite looking for almost two days on here and the internet, I'm still none the wiser, and what I can do to prevent this.
As always any help is greatly appreciated.
