Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Thanked 0 Times in 0 Posts

    Use Current Record for Query (Access 2000 SR2)

    I'll describe the problem and there may be two ways to do this. But I'm still interested i using current record for queries.


    Customer Number:
    Account Number
    Cost center Number:
    Checkbox: Done

    I want to check the box to signify that this record is finished so that the next time I open the form this record will not show up.

    Problem. Since the Form is based on multiple queries, I get the error" This recordset cannot be updated:

    A Command button that:
    Captures the Customer Number, Account Number, Cost center Number, and places it in an update query that runs in the background. The Update query will find all the records matching these 3 criterias and mark them 'done'.

    (I'll eventually need this for a "Print Current Record" button to be designed later. I have done this in the past and will research it, but any speedier help will be most appreciated!


    Another suggestion.....


  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts

    Re: Use Current Record for Query (Access 2000 SR2)

    A query can access data from the current record in a form using the syntax:
    So in your case this forms![form-A]![Customer Number]

    You can use the expression builder to build expressions like this. (it avoids typing and syntax errors)
    have the form open in the back, then in the criteria line of the query, in the relevant field, right click and choose build.
    Double Click the + next to forms, then again next to Open forms. Your form will be listed. Click it, and all the controls will be listed in the centre panel. double click the control you want and the expression you want will be displayed at the top. If it is Ok, click OK. If not, edit or delete and start again.

Posting Permissions

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