recordsetclone snapshot

[wolfedb]

I'm getting a "no current record" error when using the recordsetclone method in a continous forms load event. The forms recordset is set to a table name from the DB and the recordset type is set to dynamic. However, if I set the recordset type to snapshot then I do not get the error.

anyone have any clues why? I need the dynset type so I can edit the records on the form.

[NeoPa]

The only thing that springs to mind is that the data may be somehow locked (Check all your locking options for the database). This might explain why no records are available unless you use the snapshot type. No guarantees, but it's probably worth a check.

[wolfedb]

NeoPa thanks I'll check that out this evening. As I am new to MS Access I'm not certain how all the events work exactly but I also noticed that when I attempt to access the contents of a textbox on the form, I'm returned a null value. I am assuming that all objects and data should be available to me during the load event of the form. So what you say may actually have some merit if the records are locked than I would not be able to access any of the forms underlying data.

Does this sound correct?

[NeoPa]

I would expect the form's Load event procedure to have access to most, if not all, the objects that are available when the form is running normally. I'm not sure exactly what to expect when you have locking issues. There are possibly even multiple situations that present differently depending on your settings. You will need to discover this by checking I'm afraid.

[wolfedb]

So I just uncovered some interesting facts but I cannot figure out why to this problem. I don't think it has anything to do with record locks. I did a quick test and have found that the issue is related to using the Docmd.openform method. When I don't use this method and just open the form the me.recordssetclone actually works for snapshot and dynaset recordsets. However, if I use the docmd.openform from another form the recordsetclone method will only work using the snapshot recordset type.

As I said though I can't figure out why?

Any thoughts?

[NeoPa]

Not really I'm afraid.

In your position I'd check the top 5 or 6 properties of the form in Design view though. Make sure the Filter and Order By properties are both clear unless you want set values saved in (either of) them. Sometimes values are saved in here when the design is saved after applying a sort or a filter. It can't hurt to check it out.

[wolfedb]

I agree can't hurt and will check later. Thanks