Results 1 to 2 of 2

Thread: Filter

  1. #1
    Join Date
    May 2002

    Unanswered: Filter

    I have a table called usysbTablePasswords. This is made up of three fields: ID, FormName and Password.

    I am entering a number of formnames and the passwords for each formname into the table.

    I have a form called usysbPasswords which lists the same three fields (for the moment whilst I do some testing).

    I want to open (filter) the usysbPasswords form to a specific formname eg “ClientDetails”.

    Can you advise what the Visual Basic coding for this would be?

  2. #2
    Join Date
    Mar 2007
    "[FormName] = 'ClientDetails'" as your WhereCondition argument of the OpenForm command.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

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