Can't add a new record on sub-sub-form 
Author Message
 Can't add a new record on sub-sub-form

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



Tue, 07 Jun 2005 23:12:47 GMT  
 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


Thu, 09 Jun 2005 20:40:07 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. can't add new record to a sub-form

2. Can't add new record to sub-form

3. Can't access records with sub form for linked sub table

4. problem adding new records on sub form

5. Default values in sub-forms based on previous record in sub-form

6. Add new record to sub-form?

7. Going to a record in a Sub-form in a Sub-form

8. requery form to show new sub form record when new project

9. Sub-sub-form doesn't display data

10. Add New recrod osn sub form sets blank on main form


 
Powered by phpBB® Forum Software © phpBB Group