OZONE Asylum
Forums
OZONE
MS Access - Forms questions
This page's ID:
28777
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
i'd suggest creating a global (or public - depending on who you talk to) variable for the Employee ID number. That way you can reference that employee no matter how many forms you open. If you don't know how to set up global variables in Access, I'll post the instructions. In your first form you can use it like this: [code] Private Sub Command22_Click() gblEmployeeID = me.txtEmployeeID.Value DoCmd.OpenForm "frmLicenseAdd", acNormal, , , acFormAdd End Sub [/code] Then, in the next form: [code] Private Sub Form_Open (Cancel as Integer) me.txtEmployeeID.value = gblEmployeeID End Sub [/code] I've used this method in a lot of the Access apps that I've put together, and it works pretty well.
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail