hi,
I have a system for document management. the document table has the following fields:
document ref id: text
document id: number
document department: text
document file: number
document date: date
document type: text
document title text
document keywords:text

I need a form that allow the user to choose the field he want to search in and then type muliple words then the results shown in a subform.

how can i build a search form with feald that display the list of found records

Hi ksa266,
Not sure if I totally understood your question but,
to make a search form you need to have it dynamically create a SQL statement and then attach it to the RecordSource of the form you want the results to be in.
I usually will create an actual query with all the potential fields needed in the search, from there, I'll cut & paste the SQL statement into my code. This gives me the proper syntax very easily(needs modification of course).
I'm not sure how familiar you are with what I just said.
It can get a little tricky.
But, this is a very common way to create a search form to filter records.
Let me know if more help is needed.
Good Luck!

hello,
unfortunatly, I am a beginer in VBA. i need more description on that subject.

what i need is one two combo boxes, one text box and a subform
combo boxes are:1. to choose the form from the whole system
2. to choose the field according to the chosen form.

text box: to type the search words (one or more than one word)

subform: to display the result of the founded record.

thanksss.