Big Problem whit queries

[AndyEduardo]

I want to say thanks to Allen Browne because he answered my question an
it was very useful for me.

Now I need some help again

I have one form with one cbo, it provides information to one subform
to select what products can to buy each client, by agreement.....
selected the client in the first cbo and then in the subform comb
shows only the products in the agreement ... now what is th
problem... we agree the price of product in the agreement table bu
may be in the future the price will be not the same, .....in th
subform's combo shows the information about product.....(Name
price.....etc)

I want after update the product's cbo (taked through one querie), th
price showed in the cbo goes to one field in another table, this fiel
is not related with the agreement table...

Thank You for your attentio

 

[Allen Browne]

Use the AfterUpdate event procedure of the combo to lookup the price, and
assign it to the field in your form.

For an example, open the Northwind sample database, the Orders Subform, and
look at the AfterUpdate event procedure for the ProductID combo.

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

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

message
news:[email protected]...