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

    transparent control (Access 2000)

    i have 2 controls, one with the number of the student and another with the name.
    i can open another form only through the control with the number.However, i want this
    control to be transparent in order for the user to read a name and not a number.
    Is it possible ?

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

    Re: transparent control (Access 2000)

    What do you mean by "i can open another form only through the control with the number"?

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

    Re: transparent control (Access 2000)

    the original control students is not connected with the table.I have to paste the control studentid in order to
    open the form:
    DoCmd.OpenForm FormName:="frmCallsStudents", WhereCondition:="[StudentID] = " & Me!StudentID

    best regards

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

    Re: transparent control (Access 2000)

    If you have a table with StudentID and StudentName (or something similar), you can use a combo box instead of a text box.
    - Create a query based on the student table, with StudentID and StudentName as fields. Sort on StudentName.
    - Set the Row Source of the combo box to the name of the query.
    - Set the Column Count property to 2
    - Set the Column Widths property to 0;1
    The combo box will display the name of the student, but store the StudentID, so you can use it in your DoCmd.OpenForm instruction.

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

    Re: transparent control (Access 2000)

    That is an idea ! i am going to settle the mater now .Thank you

Posting Permissions

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