Consulting

Results 1 to 4 of 4

Thread: Access button

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

    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 Contributor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    134
    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: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    VBAX Regular
    Joined
    Nov 2020
    Location
    Swansea,South Wales,UK
    Posts
    65
    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
    1
    Location

    Reply

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


    color tunnel

Posting Permissions

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