Combo Box as Criteria for Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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...
 
Back
Top