Tips for searchable query form

[Guest]

Hello, i am new here. I want to make a form that makes my complex multi table
query user friendly.

The top 1/3 I want to use combo boxes to select the possible values for each
field. Then use a search or run button to execute the query.

The bottom 2/3 I want to display the returned records.

So, the top 1/3 never changes per se, just the bottom section depending on
user selected criteria. I have used forms once or twice in the last several
years, so I am rusty. How do I get the possible values into the combo boxes?

Gladly point me to examples if you wish. I had trouble finding ones similar
to what I want, most examples used a text box to type in criteria, I want to
select it from drop down menus. I think my biggest challenge will be with the
actual functionality itself. I can make things pretty looking later on my
own.

Thank you for the assistance.

 

[Guest]

Hi Steve,

How do I get the possible values into the combo boxes?

Set the Row Source Type to a Table/Query, and the Row Source to a saved
query or to a SQL statement, ie.:

SELECT Field1, Field2 FROM MyTable ORDER BY Field2

where Field1 and Field2 are the names of fields in your table, and MyTable
is the name of the table. Use square brackets around the field and table
names if you have included spaces or reserved words in the names of the
fields or table:

SELECT [Field 1], [Field 2] FROM [My Table] ORDER BY [Field 2]

Gladly point me to examples if you wish.

I don't have my examples posted anywhere, but if you send me a private
e-mail message, with a valid reply-to address, I will send you some samples.
My e-mail address is available at the bottom of the Contributor's page that
is shown in my signature below. Please do not post your e-mail address (or
mine) to a newsgroup reply. Doing so will only invite the unwanted attention
of spammers.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello, i am new here. I want to make a form that makes my complex multi table
query user friendly.

The top 1/3 I want to use combo boxes to select the possible values for each
field. Then use a search or run button to execute the query.

The bottom 2/3 I want to display the returned records.

So, the top 1/3 never changes per se, just the bottom section depending on
user selected criteria. I have used forms once or twice in the last several
years, so I am rusty. How do I get the possible values into the combo boxes?

Gladly point me to examples if you wish. I had trouble finding ones similar
to what I want, most examples used a text box to type in criteria, I want to
select it from drop down menus. I think my biggest challenge will be with the
actual functionality itself. I can make things pretty looking later on my
own.

Thank you for the assistance.