Enter Info into label or textbox from a gobal variable (1 Viewer)

[msiren]

I have a form that is opened by a button on a
switchboard. What I need to do is add a label or text box to the header
of that form with information that would change depending on with button
is pressed on the switchboard. That way people would know is this
instance from what district this info shown on the form is coming from.
In this case the district might be 11101 and the text box or label
should "show Shift 1 Station 1 Jan" Also this program would be on a
network. with three pc (loaded with NT) using this program. I never
wrote a program that is shared on a network, is there anything I need to
do differently? I am using Access 97

 

[Travis]

On the Form_Open Event set your label to whatever you want it to say by doing this.

Me.[lblToChange].Caption = "Type your text here as of " & Date & " for transaction " & lngTransNo

As for networking, The best way is to split the tables from the form/Reports/Querys/Macros. Place your data on the server and the other on the individual computers (Front End/Back End Approach) Also minimize recordlocking.