C
Carrie
Hi, I tried asking this in database design but so far no
answer so, I thought I'd try the Forms groups.
I have a form with 3 subforms. Each subform is bound to a
query (each query is bound to one table). The tables are
located in a backend with the queries, forms and reports
in the front end. Each form has been saved as a report
and when the staff member completes the form they hit a
print button which prints the current record. One subform
on my form will usually not contain any info, however it
needs to print on the report because it is a govt.
application. In order to make this print, I put in a
check box with a default of yes that is not visible so,
that the subform would always contain data.
This was working fine until I split the database. Now,
even though the check box is marked yes, it is not
updating the data in the query or the table. All the
other subforms and queries/tables are working fine. Can
anyone suggest how to fix this? Thanks a lot!
answer so, I thought I'd try the Forms groups.
I have a form with 3 subforms. Each subform is bound to a
query (each query is bound to one table). The tables are
located in a backend with the queries, forms and reports
in the front end. Each form has been saved as a report
and when the staff member completes the form they hit a
print button which prints the current record. One subform
on my form will usually not contain any info, however it
needs to print on the report because it is a govt.
application. In order to make this print, I put in a
check box with a default of yes that is not visible so,
that the subform would always contain data.
This was working fine until I split the database. Now,
even though the check box is marked yes, it is not
updating the data in the query or the table. All the
other subforms and queries/tables are working fine. Can
anyone suggest how to fix this? Thanks a lot!