How to select data from a sub form and move it into a printable form?

[bknabl]

I have a form that contains a text box and a combo box that is used in a query. The query results are then displayed in a subform on the main form.

On the subform I have added check boxes. I would like the user to be able to individually select the check boxes that pertain to the test plate they are attempting to order.





Problems:

1. The check boxes do not select individually. If one box is selected, all boxes become selected.

2. Once the check box issue is resolved, how do I move the data from the selected row(s) onto a new form that will be printed off.

This is being created in MS Access 2003. Thanks in advance!

[Jim Doherty]

I have a form that contains a text box and a combo box that is used in a query. The query results are then displayed in a subform on the main form.

On the subform I have added check boxes. I would like the user to be able to individually select the check boxes that pertain to the test plate they are attempting to order.





Problems:

1. The check boxes do not select individually. If one box is selected, all boxes become selected.

2. Once the check box issue is resolved, how do I move the data from the selected row(s) onto a new form that will be printed off.

This is being created in MS Access 2003. Thanks in advance!

Welcome to Bytes :)

In short this bit of your question:-

1. The check boxes do not select individually. If one box is selected, all boxes become selected.

You need to tie in that checkbox to an underlying field of the boolean type ie a Yes/No field in the underlying table by setting its controlsource. The reason they are 'all coming on at once' is due to the fact that you currently have it displayed yes.....but it is not bound to anything.

Once you have made your selections, the easiest method then is to create a simple form that has an SQL query recordsource where records are displayed from the table but restricted to WHERE the Selected field is true and where any 'other' field used on your existing search ie [Spec]="BACS" are also specified as part of that SQL's WHERE clause. Then you simply open the form using whatever logic you wish, either a button or whatever else suits you.

There are various ways however of listing and selecting multiples of records.....you are using a subform but a listbox can also do this and has the added advantage of 'multi select' simple or extended. I suggest you have a look at that feature, if all you are doing is listing and not particularly editing the record 'in place' as you might do directly in a subform, if I am making myself clear.

[bknabl]

Thanks! I will give this a try.

[bknabl]

This question is now resolved. Thank you for the help!

[Jim Doherty]

This question is now resolved. Thank you for the help!

You,re welcome :)

[bknabl]

Sorry to bring this post back up from the dead but when I first started this project, I didn't account for front end/back end. The three files I am using to drive this database are hosted on a server and are regularly maintained. With that being said, I cannot make any changes to the structure of these tables (i.e. adding a new column for selecting).

I am going back in this program and building it back up from scratch to ensure proper functionality with the user to server relationships. How do I add just a select (yes/no) column into a query that I made that has combined the three server files?

Thanks again!

[Jim Doherty]

Sorry to bring this post back up from the dead but when I first started this project, I didn't account for front end/back end. The three files I am using to drive this database are hosted on a server and are regularly maintained. With that being said, I cannot make any changes to the structure of these tables (i.e. adding a new column for selecting).

I am going back in this program and building it back up from scratch to ensure proper functionality with the user to server relationships. How do I add just a select (yes/no) column into a query that I made that has combined the three server files?

Thanks again!

I am not so sure I understand what you mean by the three files thing, elaborate