want to displaylast record

[Dave Smith]

hi,
i have 2 forms, a "client details" form & a "visits" form. when i open the
"visits" form i want a text box on that form to display the last record for
that customer. (its a "weight" record) so when the new weight is entered,
(in a different text box) you can see how much weight has been lost (or
gained) i'm fine with the maths, i just don't know how to pick up that
record.

also, can you affect the colour of the text say, if weight was up, could be
displayed as red etc?

thankyou...

dave

 

[David Lloyd]

Dave:

You can use the GotoRecord method in the form_load event to go to the last
record:

Docmd.GoToRecord acDataForm, Me.Name, acLast

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


hi,
i have 2 forms, a "client details" form & a "visits" form. when i open the
"visits" form i want a text box on that form to display the last record for
that customer. (its a "weight" record) so when the new weight is entered,
(in a different text box) you can see how much weight has been lost (or
gained) i'm fine with the maths, i just don't know how to pick up that
record.

also, can you affect the colour of the text say, if weight was up, could be
displayed as red etc?

thankyou...

dave