Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PopUp form (Access 2000)

    I want to coordinate PopUp form and main form
    From my main form i open my popup form as follows:

    DoCmd.OpenForm FormName:="frmCallsstudents", WhereCondition:="[student] = " & Me!Studentid
    My main form is a tabular form beginning with the StudentID.
    I want to open the popup form not by clicking a separate control, but by clicking the field studentid
    Then,if i click another studentid, to open the popup form for this student.
    How can i do it ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PopUp form (Access 2000)

    You can put your line of code in the On Click event of the text box bound to the StudentID field.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PopUp form (Access 2000)

    Thanks for the reply.I have problems with closing the popup form.When i click a certain client, the form opens but i do not know how to close
    it in order to click for another client.IOf ourse i could place a control on the popup for for closing it,but i wonder is there any better way
    for doing that ? I am looking for a quicker way of passing through the clients and seeing the information.
    regards

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PopUp form (Access 2000)

    Yoou could put your line of code in the On Current event of the main form. As the user moves from record to record in the main form, the popup form will be reopened at the correct record.

Posting Permissions

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