G
Guest
I'm attempting to create a form for both online use and to be printed. I
want you to be able to key on the form without effecting the format.
want you to be able to key on the form without effecting the format.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Hi, T.
Access doesn't provide much flexibility in printing a form. You have much
more control and flexibility by duplicating the form's format in a report.
Then you can provide a command button to preview the report.
To filter the report, for only the current record, place the following
criteria in the query underlying the report in the primary key field:
=Forms!MyForm!MyPrimaryKeyFieldName
Substitute the name of your form and form control in the above expression,
such as:
=Forms!Orders!txtOrderNumber
Hope that helps.
Sprinks
Access doesn't provide much flexibility in printing a form. You have much
more control and flexibility by duplicating the form's format in a report.
Then you can provide a command button to preview the report.
To filter the report, for only the current record, place the following
criteria in the query underlying the report in the primary key field:
=Forms!MyForm!MyPrimaryKeyFieldName
Substitute the name of your form and form control in the above expression,
such as:
=Forms!Orders!txtOrderNumber
Hope that helps.
Sprinks