subform not feeding table

  • Thread starter Thread starter Krazy Darcy
  • Start date Start date
K

Krazy Darcy

I have a form in a book catalog I am building that has two sub forms in it
that correctly fills in three differant tables (main table is details, sub's
are subject and authors).
I am adding a print yes/no field on a new table and using another sub-form.
However I can't get this one to work. The idea is by default the yes/no
value is yes and this is logged in a table that has record-number and print
as it's two fields. This is done so I don't havbe to search/filter through
the main table to find which records need a print-out (I will use an update
query to change yes to no after I have done the print out).

Why it is not working I don't know as the other subforms work properly.
I am using access 2003 on XP home.
 
Would it work if I had the yes/no default set to no, and if you want to print
you tick the box (set it to yes). Would this work?
I would then clear the print table after the printing has been done
(manually with the user clicking on a button
 
Yes, that would work.

Krazy Darcy said:
Would it work if I had the yes/no default set to no, and if you want to
print
you tick the box (set it to yes). Would this work?
I would then clear the print table after the printing has been done
(manually with the user clicking on a button
Click to expand...
 
Thanks for your help.

I will set default to be no, that way the user will have to tick the box to
add that record to the print que. Given the way it was misbehaving when
default was yes.
As this is an in-house system that will only be used by a few people this
will be acceptable.
 
Back
Top