Can't add a new record on sub-sub-form
Is there any code which would force a requery? That is the exact behavior
caused by a requerying or removing a filter.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Quote:
> Access 2000.
> I have a main form (form1) with a subform (form2), which has a subform
> (form3).
> Form3 has multiple records in single form mode with navigation buttons.
> If there is more than one record on form3 I can use the navigation buttons
> to go to the 2nd record, but it goes there briefly then jumps back to the
> first record.
> If I try to add a new record the same thing happens; it seems to create a
> new record, then it jumps back to the first record.
> If I close form 1 and open form2 with subform form3 I can add a new record
> on form3.
> I can't seem to find anything on form1 that would stop me adding a new
> record to form3.
> Any ideas?
> Thanks,
> Mich
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.431 / Virus Database: 242 - Release Date: 12/17/2002
