Searching Form Data

[rat_b76]

Hi All,

I am relatively new to the realms of VBA and am wanting to search a form for specific details.

I understand the DoCmd.FindRecord function, however, it does not really suit my need as I need to be able to list a return of matching records and the user to select the one which is most relevant and have this displayed in a form.

Here is more specific info;
I have a database which logs IT issues and solutions, (Fields: Title, Problem, Solution, Author and Date). I then have another form which opens up on a Search button with radio buttons listing the headings of the fields in the original form (Title, Problem etc.) with a text area for their search string.

What I want to be able to do is to have the user enter their search string, press search then display possible matches and then the user being able to select the most appropriate match and have this displayed on the original form, so they can print, manipulate etc.

As I am not that well versed in using SQL. I am wondering if this is the best option.

Can anyone help.

Rat_b76.

 

[WayneRyan]

Rat,

There are many examples of search forms here.

You can user the search facility here to look for search
forms or cascading combos.

Or you can look at this thread.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53573

Wayne