hello there,
- I have a continuous subform "Child6" with fields: PN, ProductName and Price.
- I also have a table called "Products" with the PN, ProductName, Price A and Price B.
- on the parent form i have a combobox "SaleType"
- There are also some buttons that populate the ProductName in the subform e.g. "BowlBtn" would fill up product "Bowl":
So what I would like it to do is to have the price in the subform filled up depending on the SaleType selection,if it's "Local" it would have price A, if its "Web" it would have Price B, how could I do that?Code:Private Sub BowlBtn_Click()Me.Child6.SetFocusDoCmd.GoToRecord , , acNewRecMe.Child6.Form.Product = "Bowl"End Sub
Thanks for your time in advance!