Default Value

[tmdan]

This may be very simple but I cant figure it out and it driving me nuts.

I have a form with a datasheet as a subform within it. Its is a Quote/Sale form.

I have a QuoteItems table and a Products table which I get the data for the QuoteItems subform.

I want the sell price from the Products table to populate into the actual sell price field in the QuoteItems table when I sellect the product. They are both fields in my QuoteItems subform.

I have tried to enter Forms!Quote!QuoteItems!SellPrice in the Default Value of the ActualSell but it doesn't work. I worked it out with an update query (triggerd by exiting the Item field) but if the listed sell price (in Product table) is changed and you revisit the quote it changes the ActualSell.

Any help / advice would be greatly appreciated.

[NeoPa]

I find your explanation a little hard to follow, but this (Referring to Items on a Sub-Form) link may help.
If not, come back and explain where you're stuck.

[jaxjagfan]

This may be very simple but I cant figure it out and it driving me nuts.

I have a form with a datasheet as a subform within it. Its is a Quote/Sale form.

I have a QuoteItems table and a Products table which I get the data for the QuoteItems subform.

I want the sell price from the Products table to populate into the actual sell price field in the QuoteItems table when I sellect the product. They are both fields in my QuoteItems subform.

I have tried to enter Forms!Quote!QuoteItems!SellPrice in the Default Value of the ActualSell but it doesn't work. I worked it out with an update query (triggerd by exiting the Item field) but if the listed sell price (in Product table) is changed and you revisit the quote it changes the ActualSell.

Any help / advice would be greatly appreciated.

If you are using a combobox to give yourself or sales people a list to pick from:

Make sure the datasource for the combobox contains all the desired columns (you can set column widths to 0 if you dont want the coulmns to show in the drop list).

On the AfterUpdate property of the combobox (cboProdList):

me.txtprodID = cboProdList.Column(1)
me.txtproduct = cboProdList.Column(2)
me.txtprice =  cboProdList.Column(3)

Me = your pick list form. and txtprodID, txtproduct, and txtprice would be the textboxes where you want the values stored. This would populate the quote form with the "current" product info without being affected by future product changes.

[NeoPa]

Another similar question can be found at Setting Default Value.