Field to hold price (lookup, or edit)

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

Guest

I am making a quotation form. I use a combo box to enter the item code and I
use text boxes to display from that combo box the other columns.

Currently I am using a text box to display the price column as well. But I
want the user to be able to edit the price for the particular quotation.

Any ideas would be appreciated.
 
Beverly,
I take it you have = MyCombo.Column(x) in the text control, to display
the value in the x column of your combobox.
Add a [Price] field to your table, remove the calculation form yout text
control, name it Price, and use the Price field as the ControlSource.
Then, on the AfterUpdate event of your combo...
Price = cboYourComboName.Column(x)
So, whenever a slection is made in the combo, the Price field is
updated, but still editable at any time.
hth
Al Camp
 
Back
Top