last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi plz Help.
I have a main form "frmbill" with field "capturedbilldate"
I have a sub form "subfrmbill" with fields: "BillID" "Fullname" and "Billdate"

How can I get always get the "billdate" of the last record of the subform
and get it in the "capturedbilldate" of main form?

Please help thansk
 
Use the Dmax function on BillDate in the source table for subform with the
criteria that matches a field on your main form.

If you want an exact syntax post the name of the table and field that links
the main form to sub form

Regards/JK
 

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

get last record 1
Why wont my query Show Owner Name 3
form subform design question 4
Overdue Query help needed 3
DSum Problem 4
Access Main form/Subform Navigation 0
Forms PLEASE HELP 9
Handling the 'Cancel' button..?? 1

Back
Top