Question Interfaced Search with check boxes

[Smokenwhispers]

I ask that you forgive the minor intrusion that I display by posting my question here instead of the category where it belongs. Alas, I am unaware of the relationship of my question with the categories of this forum.

As I had previously stated, I am creating a database to log licenses, permits, and the like. Most unfortunately, the ship pioneering the thought process of my mind has run aground. The destination was charted toward a database that could check whether or not I had the necessary licenses and permits to work in an area.

The concept was to have a sort of program in which the user could insert the address of the contracted work. By entering the address in the database, it would calculate all the licenses and permits involved with the contract by tracking the state and county they were associated with. It would then bring up a sort of check list below the interface to show all the licenses involved from state, county, and federal.

However, I do not have the foggiest idea about how to go about doing this...

Thank you

 

[ezfriend]

You need two tables to make this work.

Table1
License State County

Table2
Addresses

Once an address is enter, you can instruct user to click on a Search button or something to retrieve all of the licenses in Table1 where

State=The address' state
Count=The address' county

dim rs as recordset
dim ssql as string

ssql = ""
ssql = ssql & "SELECT * FROM table1 "
ssql = ssql & "WHERE State = '" & Me.state & "' "
ssql = ssql & "AND County = '" & Me.county & "' "

set rs = currentdb.openrecordset(ssql)

hope this get you started.

 

[Smokenwhispers]

You need two tables to make this work.

Table1
License State County

Table2
Addresses

Once an address is enter, you can instruct user to click on a Search button or something to retrieve all of the licenses in Table1 where

State=The address' state
Count=The address' county

dim rs as recordset
dim ssql as string

ssql = ""
ssql = ssql & "SELECT * FROM table1 "
ssql = ssql & "WHERE State = '" & Me.state & "' "
ssql = ssql & "AND County = '" & Me.county & "' "

set rs = currentdb.openrecordset(ssql)

hope this get you started.

Thank You, but I do not have individual addresses in the table. I only have State, County.