Form based on query with additional text box.

[strangeryet]

Hello,
All the fields on my form come from a single query.
I want to add a textbox to the form which will be invisible. The information in the textbox comes from a different table.

How can I include this on the form?

I tried setting the textbox's controlsource to
=tblNeeded!Field, but an "Error" displays in the text box when the form is loaded.

Thanks

 

[Remou]

How about DlookUp?

 

[strangeryet]

Yes, thank you.

I tried in controlsource, it did not work. So I put in form load and it worked:

Dim LAmount As Currency

LAmount = DLookup("MileagePrice", "tblMileageAmt", "ID = 1")

Me.txtMileagePrice = LAmount