How to automatic input price when I choose the product in order form?

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

In Northwind, I open the Order form, choose the product, the relative price
can automatic input. I want to do it in my form. Please tell me how to do
it. Thanks!
 
1. Open Northwind, and select the Forms tab of the Database window.

2. Select "Orders Subform", and click the Design button.

3. Right-click the ProductID combo box, and choose Properties.

4. On the Event tab of the Properties box, you will see the AfterUpdate set
to "[Event Procedure]" Select that line, and click the Build button ("...")
beside this. Access opens the code window.

You are now looking at the code that looks up the price for the selected
product, and assigns it to the UnitPrice text box.
 
Thank you very much!!!!

Allen Browne said:
1. Open Northwind, and select the Forms tab of the Database window.

2. Select "Orders Subform", and click the Design button.

3. Right-click the ProductID combo box, and choose Properties.

4. On the Event tab of the Properties box, you will see the AfterUpdate set
to "[Event Procedure]" Select that line, and click the Build button ("...")
beside this. Access opens the code window.

You are now looking at the code that looks up the price for the selected
product, and assigns it to the UnitPrice text box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Terry said:
In Northwind, I open the Order form, choose the product, the relative price
can automatic input. I want to do it in my form. Please tell me how to do
it. Thanks!
Click to expand...
Click to expand...
 
Back
Top