Another Day.....another issue

[MrsC]

or two.

I'm not sure if I can even do what I want to do, but let me throw it out at ya'll and see what you think.

First, I have a subform within my form that presents like a chart of sorts. I'm wondering if there is a way that I can show highlighted lines within the subform? The idea behind this is to show the most recent/working entries.

My second thing is within my main form I have a go to record function. I understand that it goes to the actual number of the line that the data is stored on. This means that it may not necessarily go to the record number that I want, just simply the line. How do I make it go to the record number not the record line. ie....... the record is #345, the line the record is located on is 364. I want the 345 and it gives me the 364.

Thanks much for any insight. :help

[Trevor]

on your 'records' question are u asking for the value to be displayed the actual (or given) record # not the auto number? if yes then just use an unbound textbox and on form current even Me!textbox = Currentrecord

and as for highlighting the most current(working record) I'm not sure how to do it, you my try a date diff and change background for that record

or just sort decending order to have the most current record displayed first.
Sorry I couldn't be of much or any help, but I gave it a shot, I hope I understood what u want.

[Trevor]

on form current event try :
Forms![main form name]![Subform Name]. Me.Recordset.Recordcount
That will refer to the current record
so try:Me.Recordset.Record count -1 to show the refer to the last entered record, and to change the highlight:
Forms![main form name]![Subform Name].[Control on subform]. backcolore = ###
for ### refere to the proporty of that textbox and click the elips (...) next to backcolor, find the color you want click ok and the # will be displaced in backcolor box just copy that # to above where backcolor = ###