Table record to TextBox?

[jschmidt]

Hello,

Is there a way to set the text in a textbox on a form to a specific value in a table in access?

I need to set txtBox.text = specific value in table

Thanks to all who can help

[MindBender77]

Hello,

Is there a way to set the text in a textbox on a form to a specific value in a table in access?

I need to set txtBox.text = specific value in table

Thanks to all who can help

You can set the controlsource property of the textbox to reflect any value. However, is you form's recordsource bound to the same table that you want to pull data from?

Bender

[jschmidt]

Yes it is bound to the same table. I am not sure how to reference the data though...

[MindBender77]

One method would be to use DLookup.

In the controlsource of your textbox

=DLookup("[FieldName]","TableName","[FieldName] = "Criteria"")

This is one way but, there are many others. What data are you trying to reference? Basically, what do you want to display in your textbox?

Bender

[jschmidt]

Perfect! Thank you very much. Works Great.