form does not show records in dynaset mode, only snapshot

[gismar]

hi!

i'm at a loss here.

after creating my form, I added data to it and the next time I started access, it did not show any of the records- they are still in the table but are not shown!!

I played with some settings and found out when i change the form type from dynaset to snapshot, I can see the data, but cannot create new entries.

I've enabled the option Cascade Update Related Fields within the relationship manager but to no avail

thanks :)

[missinglinq]

You have the Data Entry Property of your form set to Yes. This means that you can only add new records; you cannot view existing records.

When you change Recordset Type to Snapshot, in essence you reverse this because, as you found out, a Snapshot recordset is not updatable, you can only view existing records.

Set Data Entry to No and change Recordset Type back to Dynaset.You can now add new records and view existing records, which means when you open the form, the records you previously entered will be there.

Linq ;0)>

[gismar]

You have the Data Entry Property of your form set to Yes. This means that you can only add new records; you cannot view existing records.

When you change Recordset Type to Snapshot, in essence you reverse this because, as you found out, a Snapshot recordset is not updatable, you can only view existing records.

Set Data Entry to No and change Recordset Type back to Dynaset.You can now add new records and view existing records, which means when you open the form, the records you previously entered will be there.

Linq ;0)>

again this is exactly what was the case so all thanks to you :D

[missinglinq]

Glad you got it working!

Linq ;0)>