I have attached an image of the physical form
How do I use one (1) control to enable/activate another control? EXAMPLE: on a form --to use a checkbox, once checked, to enable a grayed-out field or combobox. Once said field/combobox is enabled/activated via the checkbox the choice can be selected from the combobox or typed in to the field, thereafter entered in to the databases' table(s) and/or printed on to the form I've provided herein and described below.
This is a bit of a project for me, the title/subject of this thread/discussion is only the begining.
THE GOAL: I have NCR (carbonless) forms (4-pages) see attached image/file. The data that normally (manually) gets entered into these forms, --I plan to employ Access for the task by entering all the data into Access; thereafter have the data ;pulled (queried) from Access and printed via a line printer. This appears easier said than done.
My current speed bump(s) are:
The form has various items that have a check box associated with each item. I need to be able to, via the printer, check any number of these check boxes, perhaps all of them --on the physical form--, while making the data entry in the correct field(s) within access.
example -- on the physical form we have:
heading = service type
rush x next flight x
over night x priority x
The 'x' marks a placeholder for the checkbox on the physical form --see attached image/file--
Currently, on the draft 'access form' I've created a combobox with the above listings in addition to the default listing of 'none' or 'no'. I am at a complete loss of 'how to:', after making a selection from the combobox, instead of just entering data into a table\field; what should I be reading/doing in order to both, make the entry in to the accessDB and place an 'x' in the proper checkbox on the physical form via the printer?
Assuming the database\field(s) are holding a positive value how would I tell the printer to find/associate, possibly multiple fields, with the correct listing(s) on the physical form and place an 'x' in the associated checkbox?
I hope I was clear/detailed enough without being long winded. If needed I will provide the draft 'unpopulated' database.
NOTE-1: I have attached an image of the physical form.
NOTE-2: I have not acquired the printer as yet. I needed to be sure access is able to handle what I am describing herein; these line printers are not a joke when it comes to purchasing.
How do I use one (1) control to enable/activate another control? EXAMPLE: on a form --to use a checkbox, once checked, to enable a grayed-out field or combobox. Once said field/combobox is enabled/activated via the checkbox the choice can be selected from the combobox or typed in to the field, thereafter entered in to the databases' table(s) and/or printed on to the form I've provided herein and described below.
This is a bit of a project for me, the title/subject of this thread/discussion is only the begining.
THE GOAL: I have NCR (carbonless) forms (4-pages) see attached image/file. The data that normally (manually) gets entered into these forms, --I plan to employ Access for the task by entering all the data into Access; thereafter have the data ;pulled (queried) from Access and printed via a line printer. This appears easier said than done.
My current speed bump(s) are:
The form has various items that have a check box associated with each item. I need to be able to, via the printer, check any number of these check boxes, perhaps all of them --on the physical form--, while making the data entry in the correct field(s) within access.
example -- on the physical form we have:
heading = service type
rush x next flight x
over night x priority x
The 'x' marks a placeholder for the checkbox on the physical form --see attached image/file--
Currently, on the draft 'access form' I've created a combobox with the above listings in addition to the default listing of 'none' or 'no'. I am at a complete loss of 'how to:', after making a selection from the combobox, instead of just entering data into a table\field; what should I be reading/doing in order to both, make the entry in to the accessDB and place an 'x' in the proper checkbox on the physical form via the printer?
Assuming the database\field(s) are holding a positive value how would I tell the printer to find/associate, possibly multiple fields, with the correct listing(s) on the physical form and place an 'x' in the associated checkbox?
I hope I was clear/detailed enough without being long winded. If needed I will provide the draft 'unpopulated' database.
NOTE-1: I have attached an image of the physical form.
NOTE-2: I have not acquired the printer as yet. I needed to be sure access is able to handle what I am describing herein; these line printers are not a joke when it comes to purchasing.