Selection form

  • Thread starter Thread starter GemstoneTalent
  • Start date Start date
G

GemstoneTalent

We would like a search form to return client names/basic info (select
able?) with their pictures if they match certain criteria.

The first criteria is usually SEX followed by AGE (range) and ETHNICITY.

The next group of criteria are SPECIAL SKILLS - about 150 - some categories
are ATHLETICS baseball, golf etc.; LANGUAGES; DIALECTS; ACCENTS; DANCING;
SINGING, MUSICAL INSTRUMENTS etc... Is this a candidate for a TABBED FORM?

Usually we know who to submit based on the first 3 criteria - which should
be easy to FILTER(?) on

Suggestions on the myriad of SPECIAL SKILLS? Some are YES/NO and others get
rated 0 - 4.

Is it a SUBFORM we would want to create (I just read a post that said we
cant add pix as I'd like - tell me it's not true!)

From the on screen results, is it possible to double click (or right click)
to go to the individual record (I think this has to do with creating a list
box for the first?) Or select a function to schedule a new appointment?

Suggestions are welcomed. TIA

Gemstone Talent
www.GemTal.com
 
TIA,

The short answer to your inquiry is, "Yes". You can do
all of what you are describing.

However, you would probable be better off to have one
form with all of the selectable options for selecting the
different criteria in it. You would use list boxes, combo
boxes or groups of options, based on the type of
selections that are needed.

Anyway, when all criteria is selected by the user, they
would click a button to indicate that they were finished
with their criteria. At that point you would need use
code to actually build the sql string that would then
return only the records that meet the selected criteria
to the second form. This form would could have any
information that you wanted about each record returned.

HTH

Byron
 
Back
Top