Unbound Text Box

[RevJeff]

Is there a way of linking an Unbound Text Box to a field in a table? The Form already has a different Control Source and the Table only has one Field with one value in it, but that value can change.

I just want to pull that value into the Unbound Text Box when the Form loads, but can't seem to figure it out.

Any help would be greatly appreciated.

Thanks!

 

[CJ_London]

why not just bind it to the field? you can bind the same field to more than one control.

 

[RevJeff]

The Form is bound to a different table. I'm not sure how bind a field to a different table.

 

[CJ_London]

OK - use the dlookup function

=dlookup("somevalue","sometable","somefield=somevalue")

 

[RevJeff]

Thank you, that worked perfectly.