Search Form

[data808]

I need to make a form that searches records but after I type in the search fields, I don't want it to take me to a datasheet/table kind of view. I want it to show the record in form view. The reason for this is because after the record is found I want the clerk to make changes through the form, not a datasheet/table because it seems they may make more mistakes that way. Forms are easier to fill out.



Another question is, if this is possible, I know the form only can show one record at a time so if the search finds more than one record, will I be able to just keep pressing enter to go to the next record? Is there a way that I can make it show me how many records were found on the search?

[June7]

Does not have to be datasheet view.

Consider this approach http://www.datapigtechnologies.com/f...earchform.html

Yes, that will allow navigating records if more than one meets the filter criteria.