Question Filling text fields from a table cell

[dmschenk]

I'm trying to create a report that populates some of the text fields from specfic cells from a table but can't seem to figure out just how to do it.
If this were PHP I would have something like:
(SELECT myTitle FROM myTable WHERE id="12")
But I am not seeing this in Access for a text field.


Thanks
Dave

 

[pbaldy]

Generally speaking you would base the report on a table or query (SELECT * FROM myTable WHERE id="12"). Then the control source of your textbox would be myTitle. If you want to pull data from a table unrelated to the source of the report, you can use one of the domain aggregate functions, of which DLookup() is the closest to the SQL you posted. You can't use SQL in the control source of a textbox.

 

[dmschenk]

Awesome!!!!! That did it!
Thanks

 

[pbaldy]

Happy to help, and welcome to the site!