Skip to main content
Question

How do I print a record with only certain fields showing?

  • Sep 6, 2013 4:34 PM UTC
  • 0 replies
  • 74 views

Please can someone explain how I can print a record with only some of the fields appearing? I have created a different form to populate the fields I require but not sure where to go from here.
This topic has been closed for replies.

Forum|alt.badge.img+6
  • Qrew Member
  • Sep 6, 2013 8:59 PM UTC
Make a formula URL button to redisplay the record on the Alternate Form and then print from there.

Here s an example.


URLRoot() & "db/" & Dbid() & "?a=dr&dfid=11&rid=" & [Record ID#]

Change the 11 to whatever the form id# is for your form. If you preview your form it will tell you the form ID in the URL.

  • Qrew Corporal
  • Feb 21, 2018 11:54 PM UTC
How do I add the parts I want and dont want?

Settings
Forms
  and then duplicate the form so now you have two forms.  Note that each form has a form ID#.

Carefully edit the form to remove the field you want removed.  I say carefully, just to be sure you don't mess up your main form.  Be sure which form you are editing.

You can also make a button to directly print on an alternate form.


URLRoot() & "db/" & Dbid() & "?a=printr&dfid=11&rid=" & [Record ID#]


Change the dfid=11 to the correct form ID#

  • Qrew Corporal
  • Feb 22, 2018 1:18 AM UTC
Thank you very much sir that worked great