Results 1 to 5 of 5
  1. #1
    pg13Reader is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    13

    Arrow multi-step process with click of button

    Hello, I’m hoping this is simple and someone could point me in the right direction….
    What I’d like to do is have a button (on a form) that the user can click and run the following steps:

    on click:
    1. Save record current record
    2. pull value from two fields: PolicyNum (string value, not a PK field) & PolYear (number, integer)
    3. run query (make table) based on values from step #2 above


    4. open form based off table created in step#3 above

    The step 2 to run 3 is what stumps me. The rest I figure can be done in a macro, but likely this whole process should be in VBA, which I know so little about.
    Many thanks in advance!!

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You can create a make-table query and put it in a macro attached to the OnClick. The macro can have the three steps (1, 2/3, 4). Create a query and reference the fields on the form (Forms!formname!controlname) to populate the columns on the table.

  3. #3
    pg13Reader is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    13
    Quote Originally Posted by aytee111 View Post
    Create a query and reference the fields on the form (Forms!formname!controlname) to populate the columns on the table.
    This is where I'm stumped, how would you do this?
    Thanks!!

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    I'm not sure what part you don't know. Do you know how to create a make-table query?

  5. #5
    pg13Reader is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    13
    I used: (Forms!formname!controlname) in the query, under criteria and it worked. I didn’t know this is what I was looking for. It works great now. Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compliling multi step query into single query.
    By dandoescode in forum Access
    Replies: 1
    Last Post: 12-17-2011, 02:21 PM
  2. step and step proccess
    By toochic in forum Programming
    Replies: 5
    Last Post: 10-09-2011, 09:34 AM
  3. Trying to click a button in vba
    By boywonder in forum Programming
    Replies: 8
    Last Post: 05-02-2011, 04:34 AM
  4. +1 on button click
    By 10 Gauge in forum Forms
    Replies: 4
    Last Post: 02-14-2011, 06:51 AM
  5. Replies: 4
    Last Post: 04-29-2009, 04:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums