I have built a database with a <Mainform> and a <Subform>. My problem is
twofold.
1. My subform is set as a continuos form with AllowAddiotions set to NO (ie.
a list of Issues to the client on the mainform)
2. To add new issues, a button is used and a pop-up form is used to add an
issue with more detail than what's available on the subform.
3. On accepting the new Issue from the pop-up the pop-up closes and you are
returned to the subform, and the new line is added, but the active record is
the first record and not the new one.
Problem: I have tried docmd.runcommand accmdrecordsgotolast and
docmd.GoToRecord acDataForm ,,acLast with no avail. I am getting errors
that the cmd is not available. I preface that with a requery and moving
control to the subform, either to the form itself or field on the subform,
still no luck. If I use the GoToRecord and specify the
Foms!mainform!subform as the object, I get an error that tells me the form
is not open (but it is).
Is there an easy way to move to the last record, I'm not certain what I may
be doing wrong.
The second problem I am running into is I need an event to occur when I move
out of a record (similar to onExit) and not into record that OnCurrent
provides. The afterupdate is of no use to me since changes may not occur.
Any help would be appreciated.
Thanks