If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AutoLookup in List Box
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? |
#2
|
|||
|
|||
AutoLookup in List Box
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. -- Build a little, test a little. "Donna" wrote: 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? |
#3
|
|||
|
|||
AutoLookup in List Box
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" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|