Problem with Filtering Form with Subform in Acces Data Project 200

D

Drinski67

When I aplly filter (by form) to a form with subform in Acces Data Project
2007, subform loose data; subform does'n show any data; Moveing to next/prev.
record in main form doesn't synchronise subform wich is still and always
blank; I must close and reopen form to get again subform data...

Main form contains about 50000 records and subform contains 30-60 records
related to main form selected within 1,500,000 records in table.

Moveing to next/prev. record work correctly when filter is not applied.

Acces Data Project 2007 use SQL Server 2005 Express SP2 installed on Windows
Vista Home Premium... instaled on Toshiba notebook with 2038MB RAM, Intel(R)
Core(TM) Duo CPU T2350 @ 1.86GHz Processor...
 

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

Similar Threads

insert sql form-subform problem 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Problem with form--subform 5
Duplicate record in Form and Subform 0
subform variables not showing up in main form-only one blank row with field head 3
keep subform synchronized with main form in Microsoft Access 2003 1
getting data from a main form to records in a subform 9

Top