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

Outlook meeting location auto prompts with a suggestion list - need to disable 0
ASK Field Formatting 1
Dynamic Naming of Form Button 3
Modern equivalent of Autotext in Word? 0
Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Autolookup Query to find Multiple Records 3
Outlook - Catgorizing emails by names 0

Top