Batch Form Print Command Button

[Nixeh]

Hi guys, ive been using access on and off now for about 3 years but im currently working on a database for work.

Ive got the database all sorted and is currently storing 1000records. Ive created a form that will store all the relevant information i need for a paper backup system so i can print out any report i want that ive got selected.

Though im wondering what code i would need for the button that i need thats listed below.

Needs to print, but unlike printing the current record, i need it to load to do a batch print of all the records ive got but in this form layout.

Any help will be greatly appreciated and will save me and other collegues going through and printing every form individually.

Regards, Nick

[Nixeh]

Dont worry guys managed to get it working.

Though now for some reason the other day the forms used to go through in the order they are in the database. So if they were sorted by ID they would go through 1,2,3 on the form selection, or if i sorted by surname they would go through alphabetically. But for some reason now its not doing that. Its only sorting by whether the person is deceased or not, and it shouldnt be.

[MMcCarthy]

Dont worry guys managed to get it working.

Though now for some reason the other day the forms used to go through in the order they are in the database. So if they were sorted by ID they would go through 1,2,3 on the form selection, or if i sorted by surname they would go through alphabetically. But for some reason now its not doing that. Its only sorting by whether the person is deceased or not, and it shouldnt be.

If you open the table assuming the form is based on a table you may find that the table is sorted on the deceased field.

Mary

[NeoPa]

One of the properties of a form (true for reports also) is 'Order By'.
If you enter the sort order in here you are not depending on the underlying data source.