Form to Execute Query

A

ADonMS

This issue was probably already addressed in this forum, so I apologize for
the redundancy.
I created a multi selection form that uses SQL to run the information to a
query, using unbound combo boxes that has the Row Source linked to a table
with the information I want to see.
I created form, based on Martin Green's Access Tips - "Building Queries on
the Fly".
Everything worked fine, until I updated information to the table which was
not the table used in the SQL. I created a different table that did not have
the lookup values.
I don't want to use the table with the lookup values and if I use the other,
I wil need to run a Make Table to update the data. Is this the only solution?
 

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

Similar Threads

Add additional information to excel form after original data entry 0
Crating User Form to Add Names 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Creating a Chart on form from selected data in query. 0
Append Crosstab Query to Existing Table 0
DLookup in Continuous form 0
Creating a Search using a combo box and then creating a report. 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top