Toggle field based on last recordset

[roelandkim]

I have a form, called main form, which has on subform on it. The subform is in continious form view. Basically it tracks an Out Date and an In Date. I want to make text box visible/not visible based on whether there is a value in the In date field, in the last record in the recordset. I can get the field to toggle, but I only want it to be visible if the In Date field in the last recordset is null, and if not null not visible. I have some very basic VB knowledge, so if anyone can point me in the right direction I would appreciate it.

Thanks,
Roeland Kim

 

[Fornatian]

What do you mean by...

whether there is a value in the In date field, in the last record in the recordset

How do you know its the last record entered? Is there an autonumber?

 

[roelandkim]

Yes, there is a primary key for the table, so by sorting on the PK I can determine the order of the records.

Thanks,
Roeland

 

[Fornatian]

this looks fruitful

http://support.microsoft.com/?kbid=210504