Combo Box as Criteria for Query

F

franklinbukoski

I have a combo box that when clicked provided a list of names (duplicates too
which is another issue). When clicked an after update macro prompts to open a
new form based on a new query with the
following:[forms]![Violation]![combo16], but the value doesn't get
transfered, and I'm prompted with a box that states:

[forms]![Violation]![combo16]

and I must type in a name to get the data I want.
 
K

KARL DEWEY

Is your macro closing the orignal form by chance? It has to stay open.

Test the combo by selecting name and then manually running the query.
 
F

franklinbukoski

Still gives same problem, could it be that i have a table called personnel
data with a SSN, last name, first name in it.

I then created a query to concatenate last name and first name, and show
SSN.

In a separate table I used a lookup wizard for a field SSN that uses the
concatenated query to show the personnel names, based on their SSN, SSN is
hidden. This is the table I would like to add records to, and then view only
those records based on the combo box.


KARL DEWEY said:
Is your macro closing the orignal form by chance? It has to stay open.

Test the combo by selecting name and then manually running the query.
--
KARL DEWEY
Build a little - Test a little


franklinbukoski said:
I have a combo box that when clicked provided a list of names (duplicates too
which is another issue). When clicked an after update macro prompts to open a
new form based on a new query with the
following:[forms]![Violation]![combo16], but the value doesn't get
transfered, and I'm prompted with a box that states:

[forms]![Violation]![combo16]

and I must type in a name to get the data I want.
Click to expand...
Click to expand...
 
Top