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
|
|||
|
|||
Search with a Combo Box
Hello all,
I have a question that probably has an easy answer and I'm just too fried to come up with the right phraseology to get the answer I need from the Newsgroup. I have a form and the source is the tbl_Company. I want to be able to open the form on the combobox (this is done), and be able to start typing the first few letter and the name would either pop up or do a "not in list" thing. "Not in List" I'm sure I can find, I've seen it before. It's the typing thing that won't work. It does work in the form for entering a purchase order. When I tab over to the Company combo box on that form, it filters and I can then use enter to choose that company. Can anyone help? Is my question too general? Thanks! M |
#2
|
|||
|
|||
Search with a Combo Box
I forgot to include that I wanted the address, phone, fax, etc... to all fill
in. The subforms would also need to work which shows all the purchase orders for that company. Thanks! "chickalina" wrote: Hello all, I have a question that probably has an easy answer and I'm just too fried to come up with the right phraseology to get the answer I need from the Newsgroup. I have a form and the source is the tbl_Company. I want to be able to open the form on the combobox (this is done), and be able to start typing the first few letter and the name would either pop up or do a "not in list" thing. "Not in List" I'm sure I can find, I've seen it before. It's the typing thing that won't work. It does work in the form for entering a purchase order. When I tab over to the Company combo box on that form, it filters and I can then use enter to choose that company. Can anyone help? Is my question too general? Thanks! M |
#3
|
|||
|
|||
Search with a Combo Box
It certainly seems you want to use the Combo Box to locate a particular
record. In Access 2003, the Combo Box Wizard includes this as an option... place that Combo Box in the Form's Header. I know Access 2003 was not the first version to include this feature in the Wizard, but can't remember how far back it goes. Larry Linson Microsoft Office Access MVP "chickalina" wrote in message ... Hello all, I have a question that probably has an easy answer and I'm just too fried to come up with the right phraseology to get the answer I need from the Newsgroup. I have a form and the source is the tbl_Company. I want to be able to open the form on the combobox (this is done), and be able to start typing the first few letter and the name would either pop up or do a "not in list" thing. "Not in List" I'm sure I can find, I've seen it before. It's the typing thing that won't work. It does work in the form for entering a purchase order. When I tab over to the Company combo box on that form, it filters and I can then use enter to choose that company. Can anyone help? Is my question too general? Thanks! M |
Thread Tools | |
Display Modes | |
|
|