another continuous form question.

[BLeslie88]

is there a way to either attain the last value from a text box on a form. or to get the record count of the current object....?

what I mean... let me explain it another way.

I have 10 record on a form...

If I assign the value from the text box to a variable, it gives me the first one.

I need the last one. Or the record count would suffice.

Must be from the form though, I know how to code it in vb, but my results would vary because the table constantly changes... so I need to work with the current recordsource of the form....

thanks

 

[BLeslie88]

ok...

so I figured out that if I am on the last record of the form, that is the value sent to variable...

so now I need to figure out how to access

A) the last record
B) the current record source....

 

[BLeslie88]

Well

used max function on a txtBox I will make invisible and use this to retain max order #.

If any1 know a cleaner way, feel free to reply.

Thanks.