show Last 15 records on sub form

W

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
 
W

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
 
B

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top