Design macro to search for records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with 6 unlinked input forms. Each form contains unique
records. These records are in different forms because of the different layout
/ type of their data. I am trying to design a macro which will go to the
first form, search for the record I want - if not in that form - on to the
next form etc. I am trying to do this at present with the Runcommand Find . I
find that if I use the openform command and runcommand find for each form -
the macro goes automatically to the last form and misses all the others. I am
experimenting with the runmacro command for each form but I seem to need some
sort of statement which tells the macro when to stop and/or continue - I
haven't figured yet how to combine this with the Runcommandfind. I am a
frustrated Approach user - this would be easy in Approach - but I have to use
Access - which I am slowly becoming comfortable with - I'd appreciate help.
 
John,

No offence intended, but I think you are going about this the wrong way.
This process needs to be data driven, and you need a master table for
all of the records shown on all 6 of the forms, with a field in this
table to indicate which of the 6 categories they fall into. Then your
job will be easy. Access is not like Approach.

It would really help us to help you if you would care to give some more
details about the data you are working with here, preferably with examples.
 
It sounds like you are inputting some key value then searching the 6 tables
for information that matches that key value. Did you try using the RunSQL
and building a statement with something like
Select * from Table1 where keyfield=[enteredvalue]
Duplicate that for each of the tables you want to search. You may need to
use VB rather than a macro.

(For what it's worth, I like Approach, too.)
 
Back
Top