Consulting

Results 1 to 6 of 6

Thread: Sleeper: Access button

  1. #1
    VBAX Newbie
    Joined
    Mar 2023
    Posts
    1
    Location

    Sleeper: Access button

    Hi

    Access 2021 question

    I have a student list and each have a current grade. I have a query/form where when I run the first time I get to enter the grade I’m after ie Red Belts.

    I have put button on the form to rerun the report for another result ie blue belts

    I can close the form & reopen it but can’t find how to pre fill the criteria question ie with Blue Belts

    any help would be appreciated

    thinks in advance

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    372
    Location
    I presume you are using a query with a popup input parameter. Can't 'prefill' this parameter. Must provide input from somewhere. The parameter could reference a control (textbox, combobox, listbox) on form for input.
    How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    VBAX Contributor
    Joined
    Nov 2020
    Location
    Swansea,South Wales,UK
    Posts
    113
    Location
    I would put all the belt grades into a combo, and just use that as criteria?

  4. #4
    VBAX Newbie
    Joined
    May 2023
    Posts
    2
    Location

    Reply

    Why don't you choose to aggregate the belts then use filters to get the results


    color tunnel

  5. #5
    VBAX Newbie
    Joined
    Jun 2023
    Posts
    1
    Location
    To pre-fill the criteria question on your form when you reopen it, you can utilize a global variable to store the last selected grade.

  6. #6
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Sadly, it seems Inky007 has gone to sleep on this thread
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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