Custom Search Dialogue Form - Different Search Options?

[Maillme]

Hi there, rather than me trying to describe my form - here it is:

http://server5.theimagehosting.com/image.php?img=form_capture.JPG

Basically,. this form has no coding or anything behind it - but i need to know how to get it to work, and my "using access 2000" book isn't helping me this time - and im not really a coder.


Anyhow - the 2 radio buttons, are for the user to choose which set of data they wish to search - this data is held in two different tables:

tble_issue_log - this hold my issues details
tble_training_log - this hold my training details

The radiob uttons on the right hand side refer to fields within these tables.....

log number and issue number refer only to datas within my tble_issues_log table, where as first name and surname is a field within both tables.

Anyhow - i want the user to be able to search on these fields, depending on what they pick on the right hand side, and ofcourse what they enter in the text field, but, i have no idea how to even start coding this

Any help is greatly apprecaited,

Many thanks,

Neil

 

[sunmorgus]

http://jfconsult.home.comcast.net/tips/

 

[sunmorgus]

Alternately, you can do it this way, this is how I do it in my forms, except I use combo boxed, but you should be able to work it out...

    dim searchfilter as string
    If Me.cmbSearchType.Value = "RMA Number" Then
        searchfilter = "[qryFailure]![RMANumber] Like '*" & Me.txtSearch.Value & "*'"
    End If

That code creates a filter for the open form command that edits my query [qryFailure] to only return results that are "Like * <user entered value> *". I then apply "searchfilter" to the open form command like so:

DoCmd.OpenReport "rptFailureReport", acViewPreview, , searchfilter

All of this code will go under the "Search" button on your form. Then all you would need to do is create a statement like the first one above that would be equal to each of the radio buttons on your form...