Don't want previous records viewable on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't want to see previous records on my form that is used for data entry. I have my controls recordsource properties set to populate my History table, but I dont want to be able to scroll thru old records, only ADD New ones. Thanks in advance....Brad
 
Open your form in Design view.
Open the Properties box (View menu).
Set the form's Data Entry property to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brad said:
I don't want to see previous records on my form that is used for data
Click to expand...
entry. I have my controls recordsource properties set to populate my History
table, but I dont want to be able to scroll thru old records, only ADD New
ones. Thanks in advance....Brad
 
Brad said:
I don't want to see previous records on my form that is used for data
Click to expand...
entry. I have my controls recordsource properties set to populate my
History table, but I dont want to be able to scroll thru old records, only
ADD New ones. Thanks in advance....Brad

Two choices depending on your needs.

1)
You can set the DataEntry property of the form to Yes. This will cause it
to open to the single blank position for data entry of new records. As you
create new records you will be able to scroll back and forth amongst those
records entered during that session. The next time you open the form it
will again display the single blank record. With this method the user can
get to existing records by applying a filter and can see all existing
records by using the "Remove Filter/Sort" option.

2)
Base the form on a query with always false criteria (like 1= 0). This will
also cause the form to open to a blank record for data entry, but the user
will not be able to see existing records by applying or removing filters.
If desired you can execute a Requery of the form in the AfterInsert event
and the user won't even be able to see existing records entered during the
current session. Each time a new record is saved, the form will
immediately revert to the single blank entry again.
 
Back
Top