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
 

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

Similar Threads

going to last record in a subform 4
How To Move To Last Record in Form 2
Dlookup in Form want pull data correctly from Table 4
Separate Form 0
Record Selector Shows 1 of 2 instead of total # of Records. 1
Open a sub form too last viewed record 3
DMax on existing record to increment serialized # fails 1
Main form with two sub forms 1

Top