Using a form which stays on screen to enter new criteria in Report

B

Barry Claxton

I've tried entering the code from Don Leverton's program (see site ref
below)to use a form to enter criteria for queries or reports and which stays
on screen for entry of the next criteria. I'm new to VBA and thought it would
be simple to past this stuff in, but.. I'm having problems with the SQL
(where do I put it?) and it includes a "sub routine" ("add all to a list") of
Dev Ashis (ref below) which I cant work out where to put. I'm not sure how to
comunicate with the authors (or that they'd want to bother "simplifying" it
for me!). Anyone prepared to "walk me through making it work? INITIALLY I
just want one criteria field ("Calle") [drop-down list based on a small
lookup table] on the form which opens a report based on an underlying query
("show me all the people living in Calle Mayor"). Later I will want the same
setup but on the form have two fields ("edad menor") and ("edad mayor") (show
me all the people aged between 18 and 30")

Don Leverton
http://groups.google.ca/group/comp.databases.ms-access/browse_thread/thread/7bb01959b65edcd3

Dev Ashis
http://www.mvps.org/access/forms/frm0043.htm
 
Top