MS Access - Forms questions — OZONE Asylum, home of the Mad Scientists

This page's ID: 28777

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

Edit Post