Question

[Bianca]

Hello,
I have created a product table with Article number, category, type and
price. Then I hava another created a customer form (from another table) with
all the customer information, here I have a subform (datasheet) where I enter
orders the customer has placed (using the product table) - my question is
this - is it possible to enter only the Article Number and then have the
category, type and price fields fill in automatically?
Thanks in advance
Bianca

 

[Ofer Cohen]

Look at this link on "Use the Column Property of a Combo Box"
http://www.mvps.org/access/forms/frm0058.htm

Use a combo, that include all fields needed from the table, then use the
example above to populate the rest of the fields to the form.
It's better using a combo, that way by limiting the combo the user can't
make mistakes selecting Article number that doesn't exist

Note: the column number start with 0.

 

[Bianca]

Hi
I checked out the site and I did what it said up to
' ***** Code Start *****
SELECT ID, LastName
FROM tblPersons
ORDER BY ID;
' ***** Code End *****
Set the Bound Column property of cboPersonID to 1.
Set the Column Count property to 2.
Set the Column Widths property to this expression: 1";0".
HERE (I am not yelling)

Where does this go??
Set the Control Source of a textbox (assume it's named txtPersonName) to
this expression:

=[cboPersonID].[Column](1)

Thanks again
Bianca

 

[Douglas J. Steele]

Select the relevant text box and go to the Properties window. Put

=[cboPersonID].[Column](1)

as the ControlSource property for the control.

Alternatively, you can create an event procedure for the AfterUpdate event
of the combo box, and use something like:

Private Sub cboPersonID_AfterUpdate()

Me.MyTextbox = Me.cboPersonID.Column(1)

End Sub


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi
I checked out the site and I did what it said up to
' ***** Code Start *****
SELECT ID, LastName
FROM tblPersons
ORDER BY ID;
' ***** Code End *****
Set the Bound Column property of cboPersonID to 1.
Set the Column Count property to 2.
Set the Column Widths property to this expression: 1";0".
HERE (I am not yelling)

Where does this go??
Set the Control Source of a textbox (assume it's named txtPersonName) to
this expression:

=[cboPersonID].[Column](1)

Thanks again
Bianca

Look at this link on "Use the Column Property of a Combo Box"
http://www.mvps.org/access/forms/frm0058.htm

Use a combo, that include all fields needed from the table, then use the
example above to populate the rest of the fields to the form.
It's better using a combo, that way by limiting the combo the user can't
make mistakes selecting Article number that doesn't exist

Note: the column number start with 0.