Subform DataEntry Issue

D

DeDBlanK

What is setup (each letter is nested in the previous (A->B->C):
Form C1 (dataentry=yes, ed=yes, del=yes, add=yes)
Form C2 (dataentry=no, ed=yes, del=yes, add=yes, Continuous form)
Form B (dataentry=no, ed=yes, del=yes, add=yes) Has Navigation buttons
(Prev, Next, Add all using onclick docmd.gotorecord)
Form A (DataEntry=No, Ed=yes, del=yes, add=yes)
When Form B's navigation buttons are actuated, Form C1's DataEntry property
changes to False.
The forms are linked through the master child fields.
Form A is opened from another form that is based on criteria either opens in
Add or Edit, regardless the error still happens.

I did find a thread on this issue (or at least I think it's the same.)
http://www.pcreview.co.uk/forums/thread-3849348.php
Seems that this is an Access bug? However, I didn't quite grasp the
solution in that thread. Exactly how would I run a query that would
return an empty recordset and still be able to input the data and
store it into the table?
Is there another work around for this issue?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top