|
| 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
September 21st, 2009, 10:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
September 21st, 2009, 11:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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
September 22nd, 2009, 12:44 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 | |
|
|
Linear Mode
