Create a Report from checkbox items

[FriQenstein]

Greetings all,

I am having some difficulty finding results that help with this scenario.

First, here is what I am planning, but I do not know the best method to do this.
I have an inventory and I want a user to be able to search for items and click a checkbox so that when they are finished, all checked items will be sent to the Report... kind of like creating an inventory checklist for preparing a shipment.

Say the S&R guys need to pull 5 units with specific serial numbers, they can open the form displaying units, check the boxes next to the specific units they are going to be shipping out; then they click the Generate Report form and all of the units, and pertinent information, are populated to the Report.

I have seen similar things on template based databases on the web, but most of those demo DBs do not allow access to all of the forms/query/report, so I cannot look at them in design view to get an idea of how they all work.

As I mentioned, I do not know the best way to approach this, so I am starting at zero and working forward. So far, I am just creating a form with some check boxes for testing. I do not know if Access has an inherent built in feature for this or if it will require extensive VBA coding.

Any insight would be greatly appreciated.

Thanks.

[ranman256]

the default is , all users can access all queries,tables. (tho, some complex queries can prevent users from making changes)
programmers can write code to prevent edits.

A good basic ,non programming way:
use a 'picked item' table. The users have a listbox of items to pick from,
on dbl-click ,it runs an append query to add that item to the t.PickList table
then the final SUBMIT btn to add the picked items to the target table.

if you want to use checkboxes, youd run a query to add ALL items to the t.PickList table,
instead of listboxes, youd just show the table, user would click the checkboxes needed,
then the final SUBMIT btn to add the checked items to the master table.

these are done with queries. The minor programming can be done with macros.