Combo box problem

D

Deenos

On one page I have a subform that allows the user to enter information: Last
Name, First Name etc linked to a table. On the next page subform contains a
combo box that lists the First Name and Last Name from the previously
mentioned subform. The problem is I want only the combo box to list the names
that pertains to the current record the user is on. How could I get the combo
box to do this?

Thanks. You help is appreciated.
Deenos
 
K

Ken Snell \(MVP\)

What is the RowSourceQuery value for that combobox? If it's an SQL
statement, just add a criterion to the SQL statement that checks for the
field to be equal to your form's textbox's value (the textbox that contains
the value that identifies the unique record in the form). If it's a query
name, you'll need to add the criterion to that query directly.
 
D

Deenos

Hi Ken!

I am not quite sure what is required here. The RowSourceQuery lists all the
primarykey, the title, last name and first name from the previous table, and
I added a field that concatenates the title, first name and last name into
this new field. What I am not sure about is what the criteria should look
like.

Thanks again for your help
 
K

Ken Snell \(MVP\)

Please post the RowSourceQuery value that you're using... If it's the name
of a query, please post the SQL statement of that query.
 

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