Klos, Susan
Susan.Klos at fldoe.org
Fri Aug 19 12:24:15 CDT 2005
Once I have found the record in the table I want to open a form that
shows me that record. Let me go back to my original problem. I have
several tables of contacts. I have a form with a tabbed subform. Once
I have used my find form to search my various contacts tables and found
the contact, I want the first tab to show me all the data about the
contact, then I want the second tab to show me the data from the phone
conversations I have had with that contact. These are linked through a
linking table by contactID. If the person I am trying to find is not in
one of those contact tables, then I want the form to open up blank so I
can type in the information which would be loaded into a different
'people' table. If anyone can help me on this, I would be very
grateful. Thank.s
Date: Fri, 19 Aug 2005 08:47:45 -0700
From: "Charlotte Foust" <cfoust at infostatsystems.com>
Subject: RE: [AccessD] "Find" combo box searches more than one table
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<E61FC1D4B1918244905B113C680BEA86873BD8 at infoserver01.infostat.local>
Content-Type: text/plain; charset="us-ascii"
I never understood what the user expected to "find" in such a search
function. Did they want to know every table the value appeared in, did
they want to magically "see" each record in some form? Are they
expected a treeview showing all the hits in each record in each table?
It isn't hard to find a value by walking the tables, but what did you
want to do with the results?
Charlotte Foust
Susan Klos
Senior Database Analyst
Evaluation and Reporting
Florida Department of Education
850-245-0708
sc 205-0708