View Single Post
  #4 (permalink)  
Old January 18th, 2005, 11:41 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

There are a few options for saving employee ID and using it in many forms.

1) Leave the form with employee ID open but hide it when other forms open. Then reference it with Forms.NameOfForm.Form.EmployeeID (use your real form and field names here).

2) Store the employeed ID in a temporary table with that one field and any other data you want to be available to other forms. Reference the ID from there. You can close the form instead of just hiding it.

3) Create a global variable for employee ID and store it there. You can close the form instead of hiding it.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote