Button to show all records on "Data Entry Form"

[moi]

Not quite true- you could add a record, add some more then edit an earlier just added record before closing the form. I think filtering or sorting will also clear the form

Hi.. yes you can browse the newly add records, what i mean is the older records..

 

[moi]

Hmm, never realised that, though TBH never use that either.
Just tried it out, (I like to confirm for myself as well ) and can see that records added in that session can be amended.

Thank you @CJ_London that could help me help others in the future.

Hi Gasman,

Yes, as you said, "in that session", but what i wanted is to browse older records along with the newly enter.. maybe you have some ways to display "all records" from a "data entry" form, pls share as my knowledge as beginner is very limited..

Thank you.

 

[Gasman]

Hi Gasman,

Yes, as you said, "in that session", but what i wanted is to browse older records along with the newly enter.. maybe you have some ways to display "all records" from a "data entry" form, pls share as my knowledge as beginner is very limited..

Thank you.

I always just used an Edit form and that button on the navigation bar. You could use a button of your own to toggle between Data Entry on or off?
TBH I have never ever used Data Entry = Yes, never had a separate form for adding records and another for editing.

 

[gemma-the-husky]

DoCmd.ShowAllRecords

It probably fails to work as you would like because of the behaviour of a data entry firm. A Data entry form just allows you to enter new records in this session, and not see pre existing records, so I expect showallrecords just shows the new ones in the current session. .

 

[moi]

It probably fails to work as you would like because of the behaviour of a data entry firm. A Data entry form just allows you to enter new records in this session, and not see pre existing records, so I expect showallrecords just shows the new ones in the current session. .

Hi,
So between "ShowAllRecords" vs "DataEntry"=False which one is recommendable to use?.

Thank you.

 

[GPGeorge]

Hi,
So between "ShowAllRecords" vs "DataEntry"=False which one is recommendable to use?.

Thank you.

For what purpose?

• If you want to see ALL records in the form's bound recordsource, both previously existing and newly added during the current session, you can do that by setting DataEntry to False.

A second factor is whether or not an additional filter is applied to the form's recordsource.

• If you want to apply a filter to a form's recordsource, but then remove that filter:
  
  "Use the ShowAllRecords action to remove any applied filter from the active table, query result set, or form, and display all records in the table or result set or all records in the form's underlying table or query."

https://learn.microsoft.com/en-us/office/vba/api/access.docmd.showallrecords

 

[Gasman]

If you insist on doing it your way, then use a button to toggle data entry off and on, and change button caption accordingly.

 

[gemma-the-husky]

Hi,
So between "ShowAllRecords" vs "DataEntry"=False which one is recommendable to use?.

Thank you.

If you want a data entry form, where you have clerks entering batches of new records, with no need to see records that have already been entered, then you want a data entry form..

If you are entering stock taking records it may be convenient to use data entry mode.

If you want to review all existing records then you don't want a data entry form

I have never used "show all records" and I'm not sure exactly what it does. I've never had occasion to switch a form from Data entry = true to data entry = false. You may need to requery the firm after changing the setting.

 

[moi]

If you want a data entry form, where you have clerks entering batches of new records, with no need to see records that have already been entered, then you want a data entry form..

If you are entering stock taking records it may be convenient to use data entry mode.

If you want to review all existing records then you don't want a data entry form

I have never used "show all records" and I'm not sure exactly what it does. I've never had occasion to switch a form from Data entry = true to data entry = false. You may need to requery the firm after changing the setting.

Hi, yes i used Data Entry = False.. thank you..