Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bianca - 03 Dec 2007 12:01 GMT

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

Reply to this Message

Ofer Cohen - 03 Dec 2007 16:26 GMT

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.

Signature

Good Luck
BS"D

> Hello,
> I have created a product table with Article number, category, type and
[quoted text clipped - 5 lines]
> Thanks in advance
> Bianca

Reply to this Message

Bianca - 04 Dec 2007 11:43 GMT

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
[quoted text clipped - 15 lines]
> > Thanks in advance
> > Bianca

Reply to this Message

Douglas J. Steele - 04 Dec 2007 12:21 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi
> I checked out the site and I did what it said up to
[quoted text clipped - 40 lines]
>> > Thanks in advance
>> > Bianca

Reply to this Message