combobox search for 2 fields

[Mina Garas Daniel]

Hello everyone
I need your help in this problem
I need to create a combo box as a search box
Search about item name and its serial no.
I need when I write in combo box
The item name or serial number
Display item name in a text box
All in data sheet view

I hope found solution for this in this great forum

Thanks

 

[theDBguy]

Hi. You could try starting out by using the Combobox Wizard and select the third option. You can then try to modify the code afterwards.

 

[Mina Garas Daniel]

Hi. You could try starting out by using the Combobox Wizard and select the third option. You can then try to modify the code afterwards.

Thank you
But I don't know vba codes

 

[theDBguy]

Thank you
But I don't know vba codes

You'll have to learn it eventually. Maybe we can start today. Add a Combobox to your Form using the Wizard and select the Third option. It will only allow you to search for one field, let it. We'll adjust it later to use two fields. Let us know how it goes.

 

[Uncle Gizmo]

This might be something you can use:-

Nifty Search Form - Nifty Access

Nifty Search Form This Advanced but simple to use Search Form is unbelievably easy to set-up. Just create a query and a subform. Following the comprehensive Video Instructions, which demonstrate how to add this incredible utility to your database. Establish yourself as the "Go To" person in your...

www.niftyaccess.com

contact me for details of how to get it for free...