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!
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!