I have a form that i am currently using, there is a tick option on there that i have. What i want to be able to do is when i click print form i only want the ones that have a tick at the side of them to print. Is there anything that i can put in to do that, a code or an option. Any help much appreciated. Cheers
you will probably need to set up a simple query telling the database to look for the forms that have a tick in then you should be able to print off all containing ticks
As above, but you should be able to consolidate all that into a macro. Without spending to much time, something like Action > Open Form (there is a filter command in the arguements which you should be able to set - only ticks etc) and then Action > Print Out (again set your arguments).
Don't use "Print Form" I suspect you are using datasheet view showing multiple records on the screen - rather like a spreadsheet. This is fine for adding; deleting & modifiying records. However, you now need to write yourself a report to format and print the data out. All you need to do is use the query wizard to generate a new query (based up on your table). It will walk you through filtering the records exactly as you want them. Save the query with a suitable name: sql_OutstandingOrders. Next, use the report wizard to generate a report based upon the query you just saved. Save the report with a meaningful name: rpt_MyOutstandingOrders. HTH, Stephen
