I am trying to create a search form...without recreating the wheel. What I want to do is when the search form loads...it turns on the FilterByForm. Once they have inputed all data then click a search button that will call the ApplyFilter.

I cant figure out how to call the filter by form...any suggestions?

Thank you,
John Williams

__________________
Thank you,
John Williams

I am not sure what you are trying to do? What do you want to search and how do you want the results output?


mmcdonal

I have two forms:
1) Input form where the user will enter in all their information
2) Search form (identical to input form minus the ability to input data)
- they have to be able to search by every field in the form
- I am going to also call a report from this form
- Result Output will just be pulling the data into the form. When they find the record they want they will click print and it will print it in a report.

I did figure out how to call a form in filter by form view by having
docmd.RunCommand acCmdFilterByForm in the form load. However, the catch to this view is all buttons are disabled. My solution to this is to make a custom toolbar that will allow them to apply filter, search through the matching records, and call the report.

Do you have a better solution that I can try? Is it possible to enable buttons in FilterByForm View?

I have also ran into another issue...is there a way to disable the scroll wheel from scrolling through all records in MS Access 2003 controls? or Do I have to write an activex.dll?

Thank you,
John Williams

For the scrolling issue, open the form properties, select the Other tab, and set Cycle to Current Record.

I am not sure what you need on the form issue.

mmcdonal