Subform

[gtcoglan]

Hi,

I am having problems with a subform where in the last record of the subform it is representing the value of one of the previous record fields. However the table that is populating the subform only has one record (the first record being shown in the subform refer to attachment). What I want to do is not have the last record in the subform showing the value from one of the previous records.

So how can I prevent the last record in the form from appearing as shown in the attachment.

Thanks for all your help
Greg

 

[neileg]

The subform is set to allow data entry and the line with the asterisk is where you enter a new record. If your class field defaults to 'test' then that's what appears here. If you change the subform properties to disallow data entry, this line won't appear.

By the way, you should be basing your form on a query, not the base table.