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

  • Thread starter Thread starter mac
  • Start date Start date
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
 
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
 
Back
Top