Query using form

[p2565]

Hi,
I'm a beginner in using MS Access. I need to create a form for querying data from a table. The form has has a check box for each column in the table to select the columns that need to be displayed and there are a multiple text boxes in the form where the user can specify the search parameters. The results must be displayed at the click of a button in the form.

I have not been able to find help with the VB code for running the query. I would be thankful if anyone could help me with an example of the code or direct me to help.

Thanks

[slave138]

I'm not sure I understand what you're trying to achieve with the checkboxes for the columns but you might want to see if you can modify the Query By Form example provided by MS:
http://support.microsoft.com/kb/286828

[p2565]

Thank you for the help.
Firstly, I was not able to find the 'Stored procedure' in the 'other' group of the 'create' tab in Access 2007.

The example shown does not solve my problem of selecting columns for display.

Assume, I have 5 columns (student_id, first_name, last_name, phone, email)
In the query form, I have 5 check boxes for each of the columns.
I want to implement the query such that if check box is selected, then include that column in the SELECT statement.

Eg. if first_name and last_name are selected, SELECT first_name,last_name FROM stu_table WHERE student_id = [some parameter in form].

I'd be thankful if you could help me with this.

[slave138]

If you're comfortable enough with SQL you can create an SQL string in code based on the selections made and use it as a query:

Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
Dim strSQL As String

strSQL = [Create your SQL string]

Set cnn = CurrentProject.Connection
rst.Open strSQL, cnn, adOpenDynamic, adLockOptimistic

...