Rec Selection

  • Thread starter Thread starter -z
  • Start date Start date
Z

-z

I use A2K

I am writing a Flash or Flip card prog, but what are your thoughts on how I
should do the following:

I have a frm that "flips" as I want

I have a qry built from a tbl with essentially 3 columns: ID, Category,
Term, Definition

What I would like to add to my "flip card frm" is the ability to change
categories, say, I am learning Terms and Definitions in the category
"Access," but I want to switch over and study the same way the category
"Latin" (i.e., vocabulary)

How do I change Categories, i.e., filter to the various Categories? One way
would be an Option Group, but I really don't want to have to keep adding to
this group...Could I do this with a cbo? This way I could select Categories
regardless how many, but cbo's are for indiv recs, aren't they?

Any clues, ideas, and help?

Thank you...
 
It appears that you want a main form with these various controls. Once you
complete the selections via combo boxes you would want to generate a query
that builds the data subset, from which you randomly select one record each
time you "flip", correct?

All you're doing is using combo boxes to limit data, a standard practice.
The cbo selections "filter" the data subset by providing the criteria in the
cbo selections to the SELECT clause of a query.
 
Back
Top