Just Take It ??

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

Guest

I got two forms
1)"Products And Price"
2)Invoice

In Invoice Form, I got fields ( Products , Measurements and Price)

In "Product And Price" Form, i got field ( Products, Measurement and Price)

Question:

when i choose a product and measurement in the invoice form, i want the
price to be automatically appear. The price information is dependant of the
"Products And Price" form.

In short, i want the data provided in the invoice form exactly in the
"Products And Price" Form

Any solutions? (Programmatically)


Thanks in advance

Kennykee
 
Open the Northwind sample database.
Open the Orders Subform in design view.
Look at the event procedure for the AfterUpdate of ProductID.

The sample uses DLookup() to get the current price for the selected product
from the Products table. That's the ticket.
 
Cannot Work!!!!!!!!!!!!!!!!!!!!!!!!
The error message is "You cancelled the previous operation"!!!!!!!!!!!!!
Any other solution?

Thanks

Kennykee
 
Back
Top