multi-step process with click of button

[pg13Reader]

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!!

[aytee111]

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.

[pg13Reader]

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!!

[aytee111]

I'm not sure what part you don't know. Do you know how to create a make-table query?

[pg13Reader]

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!