Form being called from Switchboard acting differently

[Mark]

OK, this is a weird one, at least to me.

I have a form called frmSoxSummaryForm. When I open this up from the Forms
menu I can scroll through and see the records that are in my table called
tblSoxSummaryTable. However when I use the switchboard I created and press
the button that calls this same form frmSoxSummaryForm I don't see nor can I
scroll through the records in my table?? I can't figure it out. The form
functions fine as far as inputting and the assorted events I have in there I
just don't see the records that I do when I open it manually. Does this make
sense?

Thanks

Mark

 

[ruralguy via AccessMonster.com]

It sounds to me like your switchboard is opening the form using the acFormAdd
DataMode argument.

 

[Mark]

And this can be switched off easily I presume? I am a bit of a novice in
this area.

 

[Mark]

Never mind. You are correct. It was Form Add. I changed to Edit Form within
the Switchboard. Thanks!!
When would you use the Form Add feature?

 

[ruralguy via AccessMonster.com]

If you only wanted to add new records and didn't want the user to see any
existing records.

Never mind. You are correct. It was Form Add. I changed to Edit Form within
the Switchboard. Thanks!!
When would you use the Form Add feature?

It sounds to me like your switchboard is opening the form using the
acFormAdd

[quoted text clipped - 17 lines]