MS Access Split Form Button Not Working

Question

Hi, 

I created a new form and set it to split form, then I added a button and added an onClick event to it. The code is very simple:

Private Sub button_Click()
  DoCmd.Close
End Sub

However this button doesn't work unless the form is not in split form, as soon as i change it to a continuous form or single form the button works. I have another split form that was created a while ago, with all the buttons working fine. 

The new split form i created has nothing on it but the button, and it doesn't work. Any idea why it is like this?

Thank you

Answer 1

Yes, a Split form is a special animal. I would not expect it to work right if there is no Recordsource and/or no data controls on it. 

Also I prefer to fully qualify my doCmd.Close statements.

DoCmd.Close acForm, "formame", acSaveNo

Answer 2

Nvm..it seems like there has to be at least one field in the split form for the button to work. Did not know that before