Search results

Many thanks for this reply. Unfortunately it prints all records and not just the one record where the focus is. However I'm sure this will come in useful at another stage in development. I managed to get it to print out just one record by, - Making the query that opens the main form and finds...

Please help! I am trying to run an OpenReport action in a macro based on a control that is in a subform. Normally, if the control was in a form I would use I would use [controlName]=[Forms]![FormName]![ControlName] as the where condation. I cannot work out how to point the where condition to the...

Access's own help features are quite good with this. It explains how to use a form to enter a criteria to open a form or report. The help topic's title is 'Use a form to enter report criteria'. I have used this for some time in a database but I have never been able to figure out how to get...