Serch Form creation in access

[aparnawangu]

Hi All,



I am very new to access programming.I want to create a search form where i can search by means of textbox and combobox for selected fields.
I need a show all button also to show all the records in one go.
I am attaching the table in XSLx format.I need to search by all the columns.
For Enquiry Form No,Timings Required,Interested In,Suitable timings of children i need a combobox search
Rest of the fields Textbox search.
Pls help me out.

[ranman256]

make a form, frmFind, that is a multi-record form to show all records.
put all your boxes to search and a FIND button.

You cant use form boxes in a query if there's nothing in them..so..
Test all controls for a possible filter then build the where clause, then filter the records.

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
if len(sWhere)>0 then sWhere= mid(sWhere,5)


  'just use the filter
iLen = Len(sWhere) - 5
If iLen <= 0 Then
    me.filterOn = false
Else
    me.filter = sWhere
    me.filterOn = true
End If

NOTE: your [timeings required] field is fine for info only, but if you mean to perform checks or queries on it , it is useless the way you have it.
But if it is just to view the time span, its OK.

[orange]

You may get ideas and inspiration from this by Allen Browne.