Using macro to perform a sequence of events

[Deehorsing]

Hello

I am trying to use a macro to open a form which accepts a value from the user,
this value is used to create run 2 queries whic create 2 tables....these two
tables are then used to open report. The problem is that when i use the
openForm to get the user input , the macro opens the report without allowing
the user to enter the value in the form. Please help if you can.
the macro is as follows

openform ...this forms contains a combo box from which the user can select
relevant values, the afterupdate event on the combobox creates the two
tables based on the value entered by the user.

open report ...this should open the report using the just created tables

Dee

 

[bhicks11 via AccessMonster.com]

If I'm understanding correctly:

Open the report with the AfterUpdate event of the combobox or whatever
control you are capturing the user input from.

Bonnie
http://www.dataplus-svc.com

 

[Steve Schapel]

Dee,

I think you will find this will work correctly for you if you set the
Window Mode argument of the OpenForm action in your macro to 'Dialog'.

 

[Deehorsing via AccessMonster.com]

Dee,

I think you will find this will work correctly for you if you set the
Window Mode argument of the OpenForm action in your macro to 'Dialog'.

Hello

[quoted text clipped - 12 lines]

Dee

Thank you very much Steve....I saw those options but I did not know what they
meant so I always use 'normal'. I do appreciate you taking the time to help
a novice. God bless you.
Dee