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
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