Populating a text box

[siamsunset]

On my form i want to populate a text box with a value from another table. For example. I have presscosts.tbl and i want to pull the value from the "kimoleccost" feild. Should i use Dlookup or ??
sorry i know its a noob question but im not sure how to do it
Ben

 

[Tanis]

Yes, use the DLookup function. Have a look at the help files for syntax and usage.

 

[Norie]

Ben

Is there any relationship between the two tables?

If there is why not base the form on a query which in turn you can base on the 2 tables?

 

[siamsunset]

There is no relationship between the 2 tables, so if i run a query , how do i pull the info i need into a text box?
cheers
Ben