Textbox value from Query

[NigelShaw]

Hi,

just a quick question. What is the best way to get a textbox to show a value from a query? im guessing an SQL string but im not very good with them.

i have a textbox on my form and need to get it to show a value from a query linked to a separate table.

any help received graciously


Nigel

 

[pbaldy]

You can't put an SQL string in a textbox control source. Try a DLookup.

 

[RossWindows]

Or you can try a combobox and put the SQL string in the RowSource.
If you want to become familar with SQL strings, start using the built-in query wizard, then in query desgin view, click the button that switches between "Preview" and "Design View" in the query, and there's an option to see the "SQL" View and that's how I learned basic sql

 

[NigelShaw]

Hi,

i will look into the SQL side of Access. The DLookup worked fine thanks PBaldy. dont know why i never thought of that before as i have only used it about 100 times!!


Nigel