Go from Add Data to Show all records???

[Russ via AccessMonster.com]

Hello,
I have a contacts form call frmContacts, I would like to open it in Add Data
(I use a macro to do this) mode but have the ability to click a button on the
form and change it to show all records, or yet another button that will
filter to a specific record. Can this be done; any suggestions would be
greatly appreciated.
Thanks

 

[Rick Brandt]

Hello,
I have a contacts form call frmContacts, I would like to open it in
Add Data (I use a macro to do this) mode but have the ability to
click a button on the form and change it to show all records, or yet
another button that will filter to a specific record. Can this be
done; any suggestions would be greatly appreciated.
Thanks

The standard menu item "Remove all Filters" will do this or applying a different
filter.

DataEntry mode is really just the application of a filter that has zero matching
records under the covers.

 

[Russ via AccessMonster.com]

How can this be done via code?

Hello,
I have a contacts form call frmContacts, I would like to open it in

[quoted text clipped - 3 lines]

done; any suggestions would be greatly appreciated.
Thanks

The standard menu item "Remove all Filters" will do this or applying a different
filter.

DataEntry mode is really just the application of a filter that has zero matching
records under the covers.

 

[Russ via AccessMonster.com]

How can this be done via code?

 

[Rick Brandt]

How can this be done via code?

Me.DataEntry = False

or

Me.Filter = "Some Filter String"
Me.FilterOn = True

 

[Russ via AccessMonster.com]

Thanks Rick, I will give it a try.

Me.DataEntry = False

or

Me.Filter = "Some Filter String"
Me.FilterOn = True