help to stop bypassing a sub form...

[Tezdread]

Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked.

Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True as default) the required field doesn't work and for some reason the Enforce Referential Integrity on the join between the main table (tblCustInfo) and this one doesn't work either.

tblCustInfo = the main form
tblAgentData = subform

can anyone please help?

 

[ghudson]

Check this out for some ideas...

A Better Mouse Trap?

Searching the forum is a great way to discover and learn the answers to your Access programming questions. As long as the links in the old posts still work!