Continuous Form (Access 2000)

Topic

New Reply

I have a continuous form which I open via a vba module.

As it is now a fairly long form, I have used

DoCmd.GoToRecord , , acLast

with the OnCurrent event to move to the end.

This works to an extent, as it shows me only the last record, at the top of the screen. Is there a way to make it show me a screen-full with the last record at the bottom of the screen?

Thanks

Reply | Quote

Replies

Yes, but it involves some code. You need to use the AbsolutePosition property of the recordset. Move to last record, get the REcordCount, the subtract a value related to how many records you want to display. For example, if your window displayes 10 records, I’d subtract 8 from the record count. This allows for 8 records + the NewRecord.

Reply | Quote