GoTo Last record ?

[ooxx]

he hi,

In the macro command to do GotoRecord ,,last . It works , the query
'qryDATA', to put the macro on the Form On open . Yes , when open the form of
bound textbox the 'qryDATA' will autorun the code the record move to the last
one.
But if we use this under the main form 'MAINFORM' -- this form is for the
form for accept data to the 'qryDATA' that created in the 'SUBMAINFORM'.
The point is when to put the data into the 'qryDATA' , the aim is to have
the 'SUBMAINFORM' to query the 'qryDATA' to the last record -- as sort the
main field 'REFNO' ascending , property of the query is to see 'All' record.
I tried to put it on every event of the 'SUBMAINFORM' , it works only at
the beginning of the when on load and on open only , any others won't do the
code of Macro command.

Thanks

 

[Van T. Dinh]

I am not sure from your description and I can only guess ...

It sound like you want to make the last Record of the Subform Recordset the
cureent Record using the GoToRecord action???

In this case, you need to use the GoToControl action first to set the Focus
to the Subform Control.

Check Access Help on the GoToControl action and read the "Tip" in this Help
topic carefully.