> never pictured it as a tapeworm before. Now I'll never forget!
They make good pets.
They go where you go, eat what you eat.....
=)
Which reminds me of eating fried mozzarella sticks,
it seems to be one of the only foods you can eat
where part of it is in your hand,
and the other end is in your stomach.
You can floss your throat if you seesaw it back and forth.
Anyhow......
I have created forms for ad hoc queries in applications.
I put a field on the form,
and added a select table code to a button next to the field.
When a table is selected,
a list box on the left side of the form is populated with the fields.
Initially, I populate the list with fields in position order,
but provide two small buttons under the list box,
to toggle sort order of the list box between position order
and alphabetical order.
This is helpful with tables that have a lot of fields,
and helps people who did not design the table,
or people not intrically familiar with the table design.
When a field in the list box gets clicked,
I add that field to mro object on the form.
The mro object has 2 columns,
one to put the name of the field,
and then one for the user to type in the criteria for the query.
Then when I click a "go" button,
a query gets created behind the scenes.
When I have used this simple technique,
I usually insist that the query return all fields in the table,
and do not do calculations in the query.
It is primitive, but has been handy several times.
Robert Wiltshire
>> Stay informed about: Creating a .frm interface for a query 
FAQ
Search
Profile
Private Messages
Log in
)