How open and search a part number in a table in VBA

M

mac

I have to create a screen which allows user to enter a part number then when
he clicks return key, it should open inventory table and search this part
number.

I am new to VBA and would really appreciate if someone please help me.

Thank you
 
L

Larry Linson

Simplest method is to include a ComboBox on your Form, and follow the
prompts in the Combo Box wizard that allow you to generate exactly what you
describe... at least in the last three or four versions of Access.

Larry Linson
Microsoft Access MVP
 

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

Adding data to MS Access from csv file 0
Page numbering with Merged Document and IF statements 1
Days inventory 0
Word Macro for multiple searches, incl. in footnotes 2
Deleting/Creating a relationship between two tables -----> Help Pl 1
"Compile error in table level validation expression " after format 0
Insert Into?? Add record to an unbound table?? 1
Building Blocks and Macros 5

Top