Selecting Fields

[Tony Mallis]

I have a query that returns a variety of student psychometric data (IQ,
reading level, etc). There are about 12 different fields that contain this
data.

I want to design an interface (switchboard, I suppose) so that staff can
access details of their students. BUT I'd like to give them a choice (on the
fly) of what fields are shown. I'd like to give them checkboxes of fields
they would like to output (to iether screen or print).

While it's easy enough to go into the query and select the fields to show,
then run the query, this would be far from the ideal.

I'm sure it's standard stuff...but I'm stumped.

Any clues??

Thanks in advance
Tony

 

[MA]

I have a query that returns a variety of student psychometric data
(IQ, reading level, etc). There are about 12 different fields that
contain this data.

I want to design an interface (switchboard, I suppose) so that staff
can access details of their students. BUT I'd like to give them a
choice (on the fly) of what fields are shown. I'd like to give them
checkboxes of fields they would like to output (to iether screen or
print).

While it's easy enough to go into the query and select the fields to
show, then run the query, this would be far from the ideal.

I'm sure it's standard stuff...but I'm stumped.

Any clues??

Thanks in advance
Tony

I'd organize it in a different way, with a submask listing all the
characteristics

It will be easier to find what you'll need

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it

 

[Duane Hookom]

I don't know what you mean by "submask listing all the characteristics" and
I doubt Tony does either.

There is a small ad hoc/"query by form" applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that
provides this type of functionality.