I have a form named invoice

it has 2 subforms on it

the first subform is a data sheet with 2 fields quote and job- combo boxes

the second one is a date sheet is based on a query that calculates the sum of the job

What i am trying to do is reference the quote and job in subform 1 and have it populate as it is selected

I have Criteria on the query for the second form as

[Forms]![Subform1]![Quote] - for quote
[Forms]![Subform1]![Job] - for job

but i think i need to first reference the the main form how would i do that

or am i trying to do something thats not possible?

You are trying to populate a textbox called My_Text in subform2 based on values in combos on subform1?
Let's assume you're trying to concatenate the two into a text box on subform2. First name the combo box different from it's row source. Quote_Combo and Job_Combo would be good choices.

Assuming both forms are running AND you're coding from within the combo's afterupdate in Subform1:
-------------------------------------------------------------------------------------------------------
Forms("Subform2").My_Text.Value = "For Job " & Job_Combo.Value & vbCrLf & "Quote: " & Quote_Combo.Value
-------------------------------------------------------------------------------------------------------

Hope this answers your question or points you in the correct direction.

If you're in the second subform and you want to reference a control in the first, you need this structure.

Me.Parent.Form.SubForm1Name.Form.ControlName

So in your case

Me.Parent.Form.SubForm1.Form.Quote


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division