show Last 15 records on sub form

[Wahab]

Dear All
I have form a "fRateListing" which is bount to a table, when I load this
form, pointer is going to the last record with "DoCmd.GoToRecord , , acLast"
with this code, its working fine. Said form (fRateListing)I m showing on
"fRateUpdate" form. I m adding the record to fRateListing from through
fRateUpdate. upto here everything working fine. I nedd the following:
After adding the record the pointer must go to last record in "fRateListing"
form which is not moveing, it remain on previous to last record. even i used
the on current "fRateListing.requery" command but no use.

Secondly i want to show only last 15 records on subform, how i will do this?
Thanks

 

[bhicks11 via AccessMonster.com]

So do you have two forms open? Is the fRateUpdate form datasource linked to
or filtered on fRateListing?

Bonnie
http://www.dataplus-svc.com

 

[Wahab]

No, fRateListing is not linked, I just drag and past it there on fRateUpdate
form. My aim is to show some records on fRateUpdate form.
fRateListing form for adding new records, deletion or changing I m using
second form.
Thanks

 

[bhicks11 via AccessMonster.com]

Drag and paste what?

Bonnie
http://www.dataplus-svc.com

No, fRateListing is not linked, I just drag and past it there on fRateUpdate
form. My aim is to show some records on fRateUpdate form.
fRateListing form for adding new records, deletion or changing I m using
second form.
Thanks

So do you have two forms open? Is the fRateUpdate form datasource linked to
or filtered on fRateListing?

[quoted text clipped - 14 lines]