Question ShowLastrecord!!

[suradj]

Dear Friends,

I hope u all are fine. I need some help.

I created 2 tabels (tblusers and tblpayment). tbluser has user information tblpayment hourly payment information.

I created a form named frmHrm. I placed the user information and payment in the form.

The payment of every user can change,so in tblpayment a user john can have different payments.

What i want is when i am openening the form of john i must see the last hoursalary record(that's the most recent one).

I am not so good in dlast,dlookup.

Can u help me please?

See attachment

 

[John Big Booty]

Try;

DoCmd.GoToRecord , , acLast

In the form's On Load event.

 

[suradj]

Dear John,

I tried this code(DoCmd.GoToRecord , , acLast) on both forms, with no result.

tblpayment is related with tblUsers(field: userid)
Relationship: one to many

other code?

 

[DCrake]

Base you subform on a query of the payements table and sort by ID Descending.

 

[suradj]

Great man . It worked. Thnx thnx

Do you have a link were i can get more access programming information?

 

[boblarson]

Great man . It worked. Thnx thnx

Do you have a link were i can get more access programming information?

Check these free tutorials out:

Access 2007

Access 2007 VBA

Access 2003

Access 2003 VBA

 

[suradj]

Thnx Man. This great