Need form field to equal the value in a column

[load3d]

I have a 1 record table that holds a value for a timer. This is a linked table. I want the value of the timer from this table to be on my switchboard(easy). Only one station has access to set the timer but all other stations need to be able to see how much time is left.. in the "timer". So what is the best way to do this? I suppose on load of my switchboard I select the value of this column into the field and then if the value is greater than 0 I set the timer interval on the switchboard to 60 seconds and refresh the form to update the value. This will allow the timer to be accurate on all stations.

Does anyone have suggestions on a better way?

If not, how do I select the timer value from the table?

Table: tbl_lockoutdatabase
Column name for timer: Timer
Field name on switchboard: timerMAINtxt

 

[load3d]

Ok I think I got it

I changed it from a text box to a combo box, created a query and used the query to select the value into the combo box. Then on timer... me.requery