Familiar old Search From Problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

HI..

Im really hoping someone can help me out. Ive scoured the forums and can see
my problem is not a new one. But still cannot find a solution to my set of
circumstances. Please help..

I have a form that Im using to search my db. (access 2003). It has 5 search
fields, (one textbox and 4 combobox). My query uses the parameters supplied
by these search fields, there is a subform based on the query on this form
too. My query criteria is Like [Forms]![SearchQuery]![boxName] & "*" Or Is
Null.

This is working except it is not returning records where there are blank
fields.

I want to place a button on the form that filters the query and populates the
subform with the results. Is this a macro? I can't figure this out. At the
moment, the subform populates once and once only.

Can someone shed some light on this for me? Its been 3 days now, Ive had this
problem..

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200605/1
.

Quantcast