Hi,
I am working on Access 97. I want to design a query which includes fields based on user input.My problem is that the User inputs not the field values so that I can set a criteria but he/she rather enters the “FIELD NAMES”.
Lets say a table in Access 97 has 10 fields with names
Last Name,First Name,Father’s Name,Mother’s Name,Age,Sex,Height,Weight,Color,Degree,Date
My task is to create a user interface for a query which is as follows.
When the user clicks on a button on an Access Switchboard to run this query,he may want to see any number of fields in the resulting dynaset.Lets say he wants to see only details about Sex,Height,Weight and Color of a particular person then
he/she will input the Last Name and First Name of that person and then, “THE FIELD NAMES” ‘Sex'(the starting field name) and ‘Color'(the ending field name) in the 4 pop up boxes which we must provide.
To summarize, we must provide 4 pop up boxes for collecting user input of these 4 items.
1) Last Name of that person
2) First Name of that person
3) NAME OF THE FIELD FROM WHERE WE SHOULD START DISPLAYING THE CORRESPONDING FIELD ENTRIES FOR THAT PARTICULAR PERSON(Last Name and First Name already entered)
4) NAME OF THE FIELD WHERE WE SHOULD STOP DISPLAYING THE CORRESPONDING FIELD ENTRIES FOR THAT PARTICULAR PERSON.
I hope I am clear and you can understand the problem.
I would really appreciate if you can suggest me a solution for this.
Thanks in advance,
Aditya Porella.