Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

altering a form according to what has already been selected

altering a form according to what has already been selected

altering a form according to what has already been selected

okay, this problem is probably quite easily fixed with code, but as I haven't had a good look at how to code VB I don't know it, and I was hoping to be able to use macros and so on anyway to make it easier for the users to change it in the future.

now for the problem, I want to be able to perform a Query from a Form, only the users want it to be a general Query with Upto five constraints/delimiters, which are to be chosen from all of the available fields from the Tables. my idea was to provide combo boxes for them to choose the fields to delimit by, or leave them as a standard or empty box if not required. Then, when they select a field from the list, a text box or group of check boxes or something for them to either select or type in the value they want the query to search by.

this may seem a little simple to some, but I can't figure it out, and if what I've written isn't understandable please let me know and I'll see if I can clarify it.

Thankyou muchly folks,
   Ben Kennedy

RE: altering a form according to what has already been selected

Ben, will you be using one table in your query or more? Using an unbound form as a place where your users can set the restrictions for the query is a good idea. How you set up the form selections can make things go even better. If you use combo boxes as the criteria your users can choose from you will eliminate the problem of misspelling. The actual code required to make the query work even if the users dont fill in all the choices can get a little more complicated but not to bad. Get back to me regarding the table structure.

John A. Gilman

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close