Subform "White Areas"

  • Thread starter Thread starter Sally
  • Start date Start date
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
 
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
 
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
 
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?
 
Back
Top