Reading Info From A Subform

[Vav]

Hello... it is late here in Canada and my head is starting to spin....

I have a problem...

I have a form called [Request_For_Quote] and that form has a subform on it called [QuoteDetails_Subform].

I want to set a text box on the master form equal to a text box on the child form.

The text box on the child form is txtSumPrice. The text box that i want it to equal on the master form is txtSubTotal.

The code that i have written is this:

txtSubTotal =[Forms]![Request_For_Quote]![QuoteDetails_Subform].[Form].[txtSumPrice]

I keep getting the code debuger saying that MS Access can not find the field [QuoteDetails_Subform]. Not sure why but, i am confused as [QuoteDetails_Subform] is not a field it is a form. It sometimes says it can't find the subform either.

Can anyone give me any suggestions. I am not sure if it has anything to do with the fact that the subform is in datasheet mode and the textbox on the datasheet that i want to look up is in the form footer.

Thanks

Peter Vav

 

[wh00t]

txtSubTotal =[Forms]![QuoteDetails_Subform]![txtSumPrice]


usage = [Object]![Object Name]![Field]

 

[Rich]

Open your main form in design view, click on the subform, click on the other tab and see what the actual name of your subform is

 

[jimbrooking]

I have found this to be a useful reference to bookmark:

http://www.mvps.org/access/forms/frm0031.htm