How do I create a lookup to other Forms/Queries?

[CindiN]

How can I create a text box on a form that will use the result of another text box (on the same form) AND the result of a control (from another form) to look up a query and enter the result from these two other criteria's? Problem is that the query is not the same query used to create the two forms mentioned above.

Form 1 Form 2 Form 2
txtbox A + txtbox B = txtbox C
from Query1 from Query2 from Query3

txtbox A data and txtbox B data are listed in Query 3 also.

Please help, I'm soooo confused!
Thanks,
CindiN

 

[CindiN]

Hello.....Please help me on this, I'm getting really desparate for an answer. I don't think it's too complicated, let me know if I need to explain myself better.

Please help!!!!
CindiN

 

[beetee]

You might try something along the lines of:

private sub MyCombo_AfterUpdate
Me.TextBox = dlookup("[FieldToPlaceInTextBox]", "QueryToLookUp", "[Field1] = Forms![Form1]![Control] and [Field2] = Forms![Form2][ControlName]&quot
end sub