one control needs to get value from other table

[wware]

My form has one table as its record source. A number of controls get their values from that table. All fine.

I need to get one other value, a rating factor, from another table and populate a textbox (for viewing only) on the form. There really isn't a relationship between the two tables so I can't just change the form's record source be a query that includes the two tables.

To me, it seems that I should just be able to set the control source property of this rating factor textbox to be a query that selects the single value that I want to put in there. When I do that I see "#Name?" in the textbox after the form loads.

When/how is the best way to get this rating factor textbox loaded?

Any help appreciated!

 

[pbaldy]

You can't set it to a query, but you can set it to a DLookup, which should accomplish the goal.

 

[wware]

Two thank yous to pbaldy

Thanks for confirming that I can't use a query. I can stop beating that dead horse.

Thanks for suggesting dlookup. I'll look into that and give it a try!

Appreciate the fast response!

 

[wware]

Works great...thanks!

Works great, just great. Exactly the answer I needed. Thanks again.