Pickup the value of the table on Form

[hfsitumo2001]

Hello, I want to pickup the value of a column in a table, but the source of the switchboard form is not from the table. I want it to show the version number on the form. I tried this:

SELECT tblLocalVariables.ID, tblLocalVariables.Value FROM tblLocalVariables

as the the source of the textbox version, but it does not work, it shows "#name" in the text box. This is my form below.

 

[pbaldy]

Try a DLookup(). You can't put SQL in a textbox like that.

 

[hfsitumo2001]

Try a DLookup(). You can't put SQL in a textbox like that.

Thank you Paul for giving us the clue, it works for me now.

 

[pbaldy]

Happy to help.