Reading Info From A Subform

Vav

Registered User.
Local time
Today, 20:00
Joined
Aug 29, 2002
Messages
36
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
 
txtSubTotal =[Forms]![QuoteDetails_Subform]![txtSumPrice]


usage = [Object]![Object Name]![Field]
 
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
 

Users who are viewing this thread

Back
Top Bottom