Building in a Search

[rescobar]

I created a simple product support FAQ data base with a form. There are 2 Cascading Combo lists, so the 2nd list is populated but the first list selection.


User input goes like this: Combo List 1 Product (select a product) Combo List 2 Model (select a product model)
Summary Field (this is a summary of an issue)
Detail field ( this is text for detail of an issue)
Solution field ( this is test for a solution)

User will use a Search Form to locate an FAQ
For a search I would like to include or not include Product and or Model. Also look for keywords in the text boxes. A search result with be one of more records in a form view.

Where should I start?

[alansidman]

Here is a good starting point

http://www.datapigtechnologies.com/f...earchform.html

[rescobar]

I think this will get me to where I need to be for the search. However I ran into another issue I want to resolve first. I have a couple of text fields that are Data Type Text, I need to change those to Memo. However I cannot change the datatype. Any ideas?

[alansidman]

Create a new table with all the fields you have in your existing table. Make the text fields in question memo fields. Create an append query from the first table and append the data into the new table. I am not sure if this will work, but I would make a stab it. You might this procedure with an update query if the append does not work.

[rescobar]

That worked. I had only a few records so I was able to rename tables and delete the orginal one. Now back to getting a search going. thanks.

[rescobar]

I hit what I sure is a small snag. In reference to the video my Clear Parameter button works. My search is not working, it's failing since it cannot find Object mainquery, this can be seen at 5:46 into the video.

Private Sub Command33_Click()
DoCmd.OpenQuery "mainquery", acViewNormal
End Sub

This part about building mainquery was not in the video but I assume I need to create a query to reference to.

[alansidman]

What is the name of your query that you want to open? If it is not mainquery, then change the VB to the name of your query.