Checkboxes and saving help

[steveo0707]

Hello,

We use Access to track our nonconforming material. Operator enters the information into an input form. The information is automatically transferred to a printable form. All of the information entered into the input form transfers over perfectly, however, i have checkboxes on the printable form that are tied to the input form drop down lists. The checkmarks were correctly transferring over to the printable form for a while, but now all the checkboxes are greyed out on the printable form.



Not sure what to look for. Also needed help on how to save the printable form on a network location. When I try to export to pdf, it wants to transfer all 6000 records, I only want to save the current record.

The formula that I have tied to one of the checkboxes is as follows, the others are similar.

=IIf([N NCMR Type]="SSP Production",True,False)

[CJ_London]

No need for the iif function, try

=[N NCMR Type]="SSP Production"

[ArviLaanemets]

My advice:

Create a report instead using the form. Base the report on a query, which returns all records from all nonconformity entries (NCMR Numbers) - like the source of your form;
Have a button on your form, where OnClick event runs the report and sends the result to printer, or to screen for preview, by setting the filter condition the [NCMR Number] equal with one for active record in your form. The report for only this record is previewed/printed;
To get the report saved as PDF-file, install a pdf-printer for your computer (e.g. CutePDF - the printer version of it is free). When printing, select the pdf-printer. You are asked where to save, and what name must be used. Maybe it is possible to design the OnClick event also to send the pdf to mail, but I haven't tried this.

[June7]

With or without IIf() expression should work.

I agree, better to print report instead of form (although I have printed forms, report is much easier to fit to paper). In either case, to print one record requires filtering to that one record.

[steveo0707]

Hello,

Operator uses "NCMR Input Form'. Input forms source is NCMR Main Table

Query created for Report is 1-NCMR Printing Form Query

1-NCMR Print Form Report is sourced by the above query.

Everything is transferring to the report, I have a open button to open the report, but the report is blank when it opens.

Also, can't get the report to display with the NCMRS in descending order.

Attachment 51399

[Micron]

I think all you posted is a shortcut, not a file. It's only 1KB in size.