How do I reset a query?


M

Mike G.

I have a table with a field filled by running a query through a combo box.
On the click, it opens up a dialog box for the user to enter a number that
should return a value from another table. This works fine if you only enter
one record. When you move to the next record and click in that particular
box, the Query does not run again and the list in the combo box shows the
previous value of the query.

Two questions:
1) Is it possible to reset the query after each use? or
2) Can I autofill the box instead of running the query?

Any help would be great!
 
Ad

Advertisements

B

BruceM

What do you mean by "running a query through a combo box"? What is "On the
click"? Is it the combo box Click event? If so, what is that event? What
is the code that returns "a value from another table"? Is this value
entered into the record, or is it merely displayed? When you refer to "that
particular box" at the next record, to what do you refer? The dialog box
where the user enters the number? Is that dialog box a form, an input box,
or what exactly?

In answer to your specific questions I can only guess that you need to
requery the combo box if you have changed its Row Source. I don't know what
you mean by "autofill the box."
 
Ad

Advertisements

J

John W. Vinson

I have a table with a field filled by running a query through a combo box.
On the click, it opens up a dialog box for the user to enter a number that
should return a value from another table. This works fine if you only enter
one record. When you move to the next record and click in that particular
box, the Query does not run again and the list in the combo box shows the
previous value of the query.

Two questions:
1) Is it possible to reset the query after each use? or
2) Can I autofill the box instead of running the query?

Any help would be great!

What is the "number" that the user is entering? Where do they get that number?
Does the query you're calling have any relationship to the query upon which
the form is based?

This sounds like a roundabout way to do things!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top