Using a Combo Box to Select Record

  • Thread starter Thread starter Chip M
  • Start date Start date
C

Chip M

I have a Form that is pointing to a Purchase Order Table
but i want the user to type in the PO# for the PO in a
text box and that record show up automatically for editing
in the form (or even after hitting a button would be OK.)
Is there anyway to do this? I am new to ACCESS and VERY
new to VB so please be gentle... Once Again, THANKS IN
ADVANCE!!!

-Chip
 
Chip,

Open the PO Form in design view. Make sure the toolbox is
visable. Select the Combo box tool and put it where you
want the control on the form. Assuming you have the
wizards installed, will ask you what you want to do (find
a record on form based on what typed) and Access will
handle the coding.

You can then look at the code for the on-click event to
see what is going on along with the combo boxes properties
(specifically data).

Jason
 
THANKS!!! That worked Great!!!
-----Original Message-----
Chip,

Open the PO Form in design view. Make sure the toolbox is
visable. Select the Combo box tool and put it where you
want the control on the form. Assuming you have the
wizards installed, will ask you what you want to do (find
a record on form based on what typed) and Access will
handle the coding.

You can then look at the code for the on-click event to
see what is going on along with the combo boxes properties
(specifically data).

Jason

.
Click to expand...
 
THANKS!!! That worked Great!!!
-----Original Message-----
Chip,

Open the PO Form in design view. Make sure the toolbox is
visable. Select the Combo box tool and put it where you
want the control on the form. Assuming you have the
wizards installed, will ask you what you want to do (find
a record on form based on what typed) and Access will
handle the coding.

You can then look at the code for the on-click event to
see what is going on along with the combo boxes properties
(specifically data).

Jason

.
Click to expand...
 
Back
Top