Subform "White Areas"

S

Sally

In a subform that has no records, what is the white area? If a subform has
records and you scroll the records, what is the white area after the last
record? I would like to be able to click in these white areas and run code.

Thanks,

Sally
 
A

Allen Browne

I think you are referring to the new record row that is the last row in the
subform - the only row if there are no records. It's there so you can type
in a new record to be added to the table.

You can test whether the new record row is current by testing the NewRecord
property of the form. Example:
If Me.NewRecord Then
MsgBox "You are in the new record row"
End If
 
S

Sally

Allen, thank you for responding!

The records in the subform are for display only. Allow Additions is set to
False so there is no new record row. I need to be able to click in the area
below the last record when I scroll and run code. I also need to be able to
click in the area of the subform when there are no records and run code. And
I need to be able to scroll the subform without running code.

Sally
 
A

Allen Browne

The area below the records in a continuous form is not programmable. It does
respond to Form_Click, but so do other areas of the screen (e.g. the record
selector).

I'm not sure how you expect to scroll the subform without running any code:
perhaps by clicking with the mouse on the scrollbar?
 
Top