Form design help

[Miked1978]

I need some help determining the best way to design thisapplication I’m being asked to write in Access. I thought I had it figured out but I’m having second thoughts.

Basically a user will need to open up a search form andselect the criteria they want to search on. This will be a handful of list boxes and date fields. I pretty much know how to design thispart.

Once the user has the parameters selected they will need toclick a search button that will run the search query and display the results ina datasheet view. From here this iswhere I’m getting hung up on.

So lets say the user selects his criteria, clicks the buttonand gets 200 records. From that 200 hemight only need 10 of those records so he will need to check (put a check in acheckbox or something of that nature) next to each of the 10 records. Or he might need all 200. Once he selects the 10 records I envision himpressing another button (maybe a submit button) that will store those recordsin a different table.

I am just not sure how to accomplish all of this. I had a query form created that would displaythe results in a subform on the bottom of the main from but I’m not sure how I wouldadd a checkbox to each record or a button that would “submit” those selectionsto another table.

The table the search query is based on is in SQL. I’dlike to keep this as a SQL backend but its not a requirement.

[GinaWhipp]

Hmm, this should help...
http://allenbrowne.com/ser-62.html

[Micron]

Have to wonder why you want to duplicate records. It's usually not a good idea.

[orange]

Mike,
I agree with Gina --that Allen Browne reference handles most search situations. I think you are focusing on How rather than What at the moment. If your criteria identifies 200 records, what is the factor that would have you choose 10 of those 200? Is it another criterion or some refinement of the original criteria? WHAT is it that would want you to choose a subset of returned records?

[Micron]

I might be missing something because I don't understand those responses. Why suggest a search form?

Basically a user will need to open up a search form andselect the criteria they want to search on. This will be a handful of list boxes and date fields. I pretty much know how to design thispart.

Why ask what drives anyone to want to select a subset of records? That is a common request and if the form is continuous the answer often given is to have a bound checkbox field that is used to mark/flag a subset of records for some purpose. However, I think the purpose is seldom to copy records from one place to another as it is here. Maybe it's because they are in linked read only tables and need to be local - that would be OK, but in that case a bound checkbox is not possible.

Sorry guys - it's probably just me missing the mark.

[GinaWhipp]

Well, maybe I misunderstood but in implementing Allen Browne's search you can do the initial search and then add a secondary filter allowing you to drill down further without having to open another Form with a simple On_Change action of a check box.

[orange]

I saw search with criteria and possible refinement--sounds like Allen Browne's article to me.
But we don't know a lot of the requirements nor some representative sample data/scenarios.