Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automated Select Criteria (A2K - SR1)

    I have a frmCheckOut based on select qryRentCalc2 that calls up a record by the operator
    entering a Receipt Number. After the from has been completed, there is a button to call
    frmSecurityDepositRefund. This form is based on another select query, qrySecurityDeposit.
    Currently the operator must enter the LastName of the guest to call the record. Frm
    SecuritySepositRefund uses data from both queries.

    Is there a way to have the name selection criteria entered automatically in qrySecurityDeposit so
    once the button is clicked on frmCheckOut, the operator does not have to enter the name?

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

    Re: Automated Select Criteria (A2K - SR1)

    I suppose that qrySecurityDeposit has a parameter like [Enter Last Name] in the Criteria line for the LastName field.
    If that is correct, you can replace the parameter by Forms!frmCheckout!txtLastName, where txtLastName is the name of the control bound to the LastName field.

    Wait a minute ... if the record source of frmSecurityDepositRefund is based on qryRentCalc2 and qrySecurityDeposit, you should be able to link these on CustomerID. Isn't that sufficient?

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automated Select Criteria (A2K - SR1)

    Many thanks for your solution.

    Tom

Posting Permissions

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