subform not feeding table

[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.

 

[Mark A. Sam]

Darcy,

It appears like you are expecting the Yes/No field to populate on its own
automatically without entering data into the subform. That won't happen. A
new record needs to be create in the subform for the default value to
populate the field. You can do this manually by enter data into another
field or through programming.

God Bless,

Mark A. Sam

 

[Krazy Darcy]

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

 

[Mark A. Sam]

Yes, that would work.

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

 

[Krazy Darcy]

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.