AutoLookup in List Box

D

Donna

I am new to Access 2007 but have a lot of experience with the older versions
of Access and the wizard use to ask if you wanted to find a record based on
what you select in your list box. Well Access 2007 doesn't seem to have that
feature and I don't know who to get it to work without it. Can any one help?
 
K

KARL DEWEY

Use listbox on form and reference it in the query like this --
[Forms]![YourFormName]![ListBoxName]
You can add 'Like' and wildcards in front and/or behind.
 
L

Larry Daugherty

The behavior you describe is offered for a ComboBox, not a ListBox.
That is if you are in design mode and the wizards are enabled.

HTH
--
-Larry-
--

Donna said:
I am new to Access 2007 but have a lot of experience with the older versions
of Access and the wizard use to ask if you wanted to find a record based on
what you select in your list box. Well Access 2007 doesn't seem to have that
feature and I don't know who to get it to work without it. Can any
Click to expand...
one help?
 

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

AutoLookup Combo Box for fields/northwind 2
Autolookup Query to find Multiple Records 3
MultiSelect List Box (pre Access 2007) 3
Adding a new record in an autolookup query? 1
Autolookup expression example 1
Query/Table Autolookup within another Table 5
add a record in an autolookup query 1
Allowing both multiple values and list edits in Lookup field 3

Top