Thread: Missing one line of code
05-21-14, 15:01 #1Registered User
- Join Date
- May 2014
Unanswered: Missing one line of code
If Y = 2 Then
DoCmd.OpenForm "frm a"
Missing line of Code :What I want code to do here is (If button c is clicked on frm a then following should happen)
DoCmd.OpenForm "frm b"
Forms!frm b!txtUserID = X
Forms!frm b!txtUsername = txtUsername
Forms!frm b!combo1.Visible = False
As both forms gets open simultaneously and menu menu which is form a goes at the back of form b
05-22-14, 04:36 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
so place the code in your button c's on click event
rather than pass the user id from form to form, it would be smarter to push the user id into a global variable in a code module.
actually it would be smarter yet to use the users network logon api and not store it at all... google:- dev ashish api
then assign the netowrk logon to your users table, make certain your corporate policies only allow one logon per userid and you dont' need users to think up passwords for your application. let the OS handle the security and your app allocate resources as you seem fitI'd rather be riding on the Tiger 800 or the Norton