order forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one product table containing product number, description and price. I
want to create a form that will automatically fill in the description and
price when I select the product number from a combo box. I also want a
calculated field based on the price and a final total. I have been using
excel for this and am wondering if access is the program I should be using.

thanks
 
The Row source of the combo should include all three fields.
Select [product number], description, price From [product table]

On the after update event of the Combo box write the code
Me.[descriptionFieldnameInTheForm] = Me.ComboName.Column(1)
Me.[priceFieldnameInTheForm] = Me.ComboName.Column(2)

Now about the third field with the calculation, I don't know what exactly
you need but there an example
Me.ThirdFieldName = Me.ComboName.Column(2) * Me.SumFieldName

The column number of the combo start with 0
 
Back
Top