Linking Macros - easy one

[Julia]

Hi

New to Access so need help!

How do I link marco actions,,,

i.e

I want a macro to...

open query
display the result in the form (rather than the table)


Help!


Thanks

 

[RuralGuy]

That just magically happens if you open a form bound to a query.

 

[MSAccessRookie]

Hi

New to Access so need help!

How do I link marco actions,,,

i.e

I want a macro to...

open query
display the result in the form (rather than the table)


Help!


Thanks

When you open a query you will see a Query DataSheet, (which resembles a Table). In order to view it as a Form, Open the query, and create the Form using the New Object Button.

Note: I noticed that RuralGuy had offered another approach to the same thing. If you create a NEW Form that is based on the query you already have, you will have the same result. I approached your issue considering the Query you had, and he approached it considering the Form that you desired. In the end the result will be the same.