Auto Fill Fields for Order Entry Detail

[E.C.]

I am attempting to create an order entry database and I have set up
all the different tables I need. Right now I am trying to attempt to
create an order entry detail subform (like the one in the Order Entry
Template in Access)- but I am not sure how to get some info to auto
fill.
The Product Table that has the following fields:

P_Product Code
P_Product Name
P_Kit Size
P_Unit Price

I want users to be able to enter in there orders into the order detail
and have them select the Product Code and then all the other info will
auto fill with defaults and then the user can change the info if they
need to.

Can anyone point me in the right direction?
Thanks!

 

[Arvin Meyer [MVP]]

Build a combo box named ProductCode with a rowsource like:

Select [P_Product Code], [P_Product Name],[P_Kit Size],[P_Unit Price]
From tblWhatever

Bind the control to: P_Product Code

Set the Column Count to: 4

and the ColumnWidths to:

0";1.5",0";0"

Set the bound column to: 1

Now create 3 text boxes for the data in columns 2 through 4 and set their
countrolsource property to:

=Forms!MyFormName!cboProductCode.Column(1)
=Forms!MyFormName!cboProductCode.Column(2)
=Forms!MyFormName!cboProductCode.Column(3)

 

[Srowe]

would this work for a multiple of fields. I have approximately 20 fields that
I am trying to auto complete upon entering the last name of a person. All
data from the fields is stored in the same table (table:subject) with fields
ranging from names (first, last and middle) to the address and phone number.

Thanks in advance.

Build a combo box named ProductCode with a rowsource like:

Select [P_Product Code], [P_Product Name],[P_Kit Size],[P_Unit Price]
From tblWhatever

Bind the control to: P_Product Code

Set the Column Count to: 4

and the ColumnWidths to:

0";1.5",0";0"

Set the bound column to: 1

Now create 3 text boxes for the data in columns 2 through 4 and set their
countrolsource property to:

=Forms!MyFormName!cboProductCode.Column(1)
=Forms!MyFormName!cboProductCode.Column(2)
=Forms!MyFormName!cboProductCode.Column(3)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am attempting to create an order entry database and I have set up
all the different tables I need. Right now I am trying to attempt to
create an order entry detail subform (like the one in the Order Entry
Template in Access)- but I am not sure how to get some info to auto
fill.
The Product Table that has the following fields:

P_Product Code
P_Product Name
P_Kit Size
P_Unit Price

I want users to be able to enter in there orders into the order detail
and have them select the Product Code and then all the other info will
auto fill with defaults and then the user can change the info if they
need to.

Can anyone point me in the right direction?
Thanks!