Help creating a search form

[ttn022191]

Hello all,

I need help creating a search form. I have no knowledge of SQL and I've looked at many examples and can't seem to figure this out. I've attached the database and hopefully someone can give me some help with the SQL code to create this search form. I created the layout of how I want to the search form to look like and it is saved as "ReadingSearchForm". It has 5 multi-select list boxes and 4 combo boxes. I want the user to select the criteria from the list boxes and combo boxes and the information will appear in a subform.

If anybody could help me that would be great!

Example.zip

[ranman256]

You would have to inspect each control to see if they picked it. like:
On Search_click()

dim sSql as string, sWhere as string

if not isnull(cboState) then     sWhere = sWhere & " and [state]='" & cboState & "'"
if not IsNull(txtName) then    sWhere = sWhere & " and [Name]='" & txtName & "'"
if not IsNull(chkContact) then    sWhere = sWhere & " and [Contact]=" & chkContact.value

    'remove 1st And
sWhere= mid(sWhere,4)
sSql = "SELECT * FROM tblCompany WHERE "
sSql = sSql & sWhere

frmResults.Recordsource = sSql

[ttn022191]

I don't really understand this...

[ranman256]

The user can click on any 1 or more , of the elements on the page. Youd have to inspect all of them to determine what is wanted.
The result is in the sub form.

Unless you understand access, this is a simple as I can make it.

[AlexHedley]

Have a go replicating this idea, it uses a textbox to get the Search Criteria but if you understand this then you can expand it to use your controls.

https://599cd.com/tips/access/multi-...rch-form-like/

[alansidman]

You might have a look at this tutorial to get you started. You can modify your form once you understand the basics from this video.

http://www.datapigtechnologies.com/f...earchform.html