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.
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.