By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,608 Members | 1,925 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,608 IT Pros & Developers. It's quick & easy.

How to setup a Macro with a Drop Down Query...

greeni91
P: 61
Hi all,

I am using a database at my workplace that has over 3000 records and I have been told to make queries for it. As of now i have the queries complete and I am compiling the macros to run them from a switchboard.

Each of my queries is made of two parts: one half is the user input FORM which I need to use drop down lists on and second is the query itself. When I run them like normal they are fine but what I need to do is:
  1. Open the input form for the query
  2. Set the criteria from the form and click OK (runs the query)
  3. Apply the results of the query as a filter on my Development Reports form

A few other things about my queries is that they all have OK and Cancel buttons. This means when I open the form I can set the criteria on the form and click OK, this opens the query in NormalView and applies the criteria I just set.

When I tried to set the macros I ran into all sorts of problems. I am just using the macros on the Database Window (for clarification). I am not sure if creating the macros in VBA would be easier.

Any help is greatly appreciated,

/Sandy
Mar 30 '10 #1
Share this Question
Share on Google+
1 Reply


100+
P: 109
Creating code in VBA will be easier than recording macros, I think. For anyone to be able to help you though, you're going to have to post your database structure and existing queries as it's very difficult to picture what it is you require from what you have written.
Mar 30 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.