Me.Recordset.MoveLast

A

Access101

I've created 3 forms and 3 subForms with 3 separate tables bound to each
subform, in the following manner:

I created frmA & sfrmA.

Because the design of the next two forms were going to be very similar, I
did a Save As twice, creating the following:

frmB & sfrmB
frmC & sfrmC

I added this code to the Form OPEN routine for all 3 subFroms A-C

If Me.Recordset.EOF = False Then
Me.Recordset.MoveLast
End If

The code works correctly in all 3 of them in that it jumps to the last
record, and displays the NEW RECORD Asterisk on the record selector for all 3.

However, I can only Edit or Add new records to A & B, not C.

When I REM out the code in C, I can then Edit and Add new records.

Or if I leave the code in the sfrmC, and take the sfrmC OUT OF frmC, and run
it as a Parent, it works correctly all around.

Please help!

I’ve recreated a Parent form for sfrmC, and this seems to have fixed the
problem. But I’d sure like to know what was wrong: "obviously" in the Parent
form.
 

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

Top