Unboud cell reference

[Legends77]

The form's source is table X which has 99.9% of the data, however I would like to include field [value] from the table [tblLocalVariables] in text55
I have tried each of these in the "On Open" event, but none works:
me.text55=[tblLocalVariables].[Value]
me.text55=[value].[tblLocalVariables]
me.text55=([tblLocalVariables].[Value])
me.text55=([value].[tblLocalVariables])

This is just an info box telling them the last time the database was updated so that they don't run all the reports, etc, then end up calling me asking why it is not up to date or as to what date it is thru.
This table is also used for the autoupdating feature the database has so that is why I would like to use it and not insert a note. (found too many times in the past when I was not here to update, someone else may update but forget to update small items like "notes", so just trying to avoid extra work in the long run.)

 

[kjv1611]

Well, the problem is you're trying to pull the whole list of values by just pointing at the table and field. You need to reference the table with a query. The easiest way to do this will be to use a ComboBox or ListBox rather than a TextBox, and then using the ComboBox or ListBox's properties for rowsource, hit the build button, and well, build what you want it to show. If you need a where condition, simply plug that in.

 

[Legends77]

Thanks! Worked great!