Search Form.

[injanib]

I have asked this before, but I never got an answere. I guess because I was
not very clear.
I have a form that has plain text boxes and combo boxes. I enter data in the
form and save them and then make changes to them later. For example I enter
start dates, end dates and make selctions from combo boxes and save them.

I would like to have another form on which I can search by start date, end
date or by the selections from the combo boxes. I would also like to be able
to chose more than one crieteria for my search. I want the form to display
the result in the form footer. Here is the trick part. I want to be able to
make changes to the search result in the footer and save them.

I have looked at the codes at this link.
http://allenbrowne.com/ser-62.html
but I don't know where I need to put this code and I don't think I can make
changes to the search result.

any body with a solution????

 

[Guest]

You can create a form to do this for you, but the easiest way to do this is
to use the Access FilterByForm method.

If you open your form, then right click on the form, you should have an
option that says "Filter By Form". If you select this, all of the controls
on your form will go blank, and you can enter values in them. The combo
boxes will have drop down values, and the text boxes will be empty. You can
either clear the combo boxes or select an item. In the text boxes, you could
enter >#7/6/07# or other date related criteria. When you are done refining
your filter, right click on the form again and select the "Apply Filter /
Sort" option. This will filter your forms recordset so that only the records
that meet your criteria will display. When you are ready to remove the
filter, right click and select "Remove Filter/Sort"

HTH
Dale

 

[injanib via AccessMonster.com]

That does the job to a certain level of my satisfaction. But I have created a
button to perform the form filter. Now when I click the button it does not do
what it does if you chose the filter by form by right clicking on the form.
It just pulls the same record everytime.

I like to have a button to do this instead of having to right click verytime
and chosing the filter that way.

You can create a form to do this for you, but the easiest way to do this is
to use the Access FilterByForm method.

If you open your form, then right click on the form, you should have an
option that says "Filter By Form". If you select this, all of the controls
on your form will go blank, and you can enter values in them. The combo
boxes will have drop down values, and the text boxes will be empty. You can
either clear the combo boxes or select an item. In the text boxes, you could
enter >#7/6/07# or other date related criteria. When you are done refining
your filter, right click on the form again and select the "Apply Filter /
Sort" option. This will filter your forms recordset so that only the records
that meet your criteria will display. When you are ready to remove the
filter, right click and select "Remove Filter/Sort"

HTH
Dale

I have asked this before, but I never got an answere. I guess because I was
not very clear.

[quoted text clipped - 14 lines]

any body with a solution????