Does acNewRec bring down the whole RS?

[Premy]

Hi there,

I have a form with the DataEntry property set to True. I suppose this guarantees that the (whole) rs of the underlying table is not loaded into memory. Say that, after I've filled in a new record this way and saved it, I want to go to a new record via "DoCmd.GoToRecord, , acNew"... will this then bring down the whole rs of the underlying table, or is Jet intelligent enough to just add to the recently inserted record? For if it's not I'll have to look for an alternative (probably closing and reopening the form) to ensure I do not needlessly load thousands of records into memory.

Thanks in advance for your attention

Regards,
Jaime Premy

 

[missinglinq]

I have a form with the DataEntry property set to True... I want to go to a new record via "DoCmd.GoToRecord, , acNew"

If you have DataEntry set to True, why in the world would you want to use

DoCmd.GoToRecord, , acNew

instead of simply clicking on the AddRecord button?

 

[Premy]

If you have DataEntry set to True, why in the world would you want to use

DoCmd.GoToRecord, , acNew

instead of simply clicking on the AddRecord button?

Thing is I disabled the nav buttons, so I had to put a button to do just that: go to a new record.
But either way the question remains the same: does it or doesn't it bring down the whole rs from the underlying table into memory? I mean Jet has to know somehow where the last record is in order to insert a new record. My doubt is just like I asked: given the fact that I added a new record in DataEntry mode, does Jet add to just this record or retrieve the whole shebang when I do "DoCmd.GoToRecord, , acNew" (or when I click the AddRecord button if you like).

I guess this is the kind a thing we only discover by trial and error, since I wasn't able to locate any documentation on the subject, so I appreciate any help from more experienced users.

Regards,
Jaime