Search Form - print

[jomuir]

I have been on numerous topics on this site and managed to pick up bits here and there to get my db to work as I would like with the exception of the print report button.

I can preview the result in a subform of the search that I have done, and it is this I would like to print – not sure what this should be as you can search on numerous criteria.

Edited - removed code and added file

 

[g28dman]

See Attached

I kinda ripped it up a little bit. but, I added a unbound text box to your frm Search mirroring the voucher number on frmsubclients.

I created another query where the criteria matches that unbound text box and used this query to run the report. You can make the text box visible=no.

i do not understand your table though, it seems like you are entering as a spreadsheet. Maybe I am wrong, though on that.

 

[jomuir]

Hi - sorry had a few weeks off

The actual data is something like 600,000 archived records, and it has been saved in Access, so yes it is just a flat spreadsheet, but I wanted to add the search screen and print capabilities to it.

This does not really do what I wanted - this prints only the actual record that you are looking at and not all the records returned via the search.

Can you think of anything else? I will upload on that version where I have the printing working as I require it, but I can only search on one field in this one........I need a combination of them both!!