Results 1 to 2 of 2
  1. #1
    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

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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 fit
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts