Not showing all records

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Everyone,

I have a form that I want to show all the records. Usually I have a 1 of
3333 and can scroll through the list of patients using the record selectors.
It was working until I moved the database to another drive and then back to
the original location. Now when I open up the form, the record selector is
at 1 an any new records I enter show up until I close it and then they are
hidden again.

Access 2000


Thanks,
Linda
 
Sounds as if the form's DataEntry property has been set to Yes. You need to
reset it back to No.
 
It is set to no.

In the properties for Filter..........[ClientID]=3374

For the On open Procedure it is

Private Sub Form_Open(Cancel As Integer)
Forms![Clients].Refresh
DoCmd.ShowAllRecords
[Find Client].SetFocus
End Sub


Does this help solve my dilemma? If not, what else do I need to add?

If I click on the filter by form button on the toolbar, I get 1 of 17
records and if there is nothing in a certain field (the chart location
field) those records are the 17 showing.

Thanks,

Linda
 
Delete the string from the Filter property so that it shows a blank box.
Save the form. Try it then.

--

Ken Snell
<MS ACCESS MVP>

LMB said:
It is set to no.

In the properties for Filter..........[ClientID]=3374

For the On open Procedure it is

Private Sub Form_Open(Cancel As Integer)
Forms![Clients].Refresh
DoCmd.ShowAllRecords
[Find Client].SetFocus
End Sub


Does this help solve my dilemma? If not, what else do I need to add?

If I click on the filter by form button on the toolbar, I get 1 of 17
records and if there is nothing in a certain field (the chart location
field) those records are the 17 showing.

Thanks,

Linda

Ken Snell said:
Sounds as if the form's DataEntry property has been set to Yes. You need to
reset it back to No.

--

Ken Snell
<MS ACCESS MVP>

back
to selector
is
Click to expand...
Click to expand...
 
It worked!

Thanks,
Linda

Ken Snell said:
Delete the string from the Filter property so that it shows a blank box.
Save the form. Try it then.

--

Ken Snell
<MS ACCESS MVP>

LMB said:
It is set to no.

In the properties for Filter..........[ClientID]=3374

For the On open Procedure it is

Private Sub Form_Open(Cancel As Integer)
Forms![Clients].Refresh
DoCmd.ShowAllRecords
[Find Client].SetFocus
End Sub


Does this help solve my dilemma? If not, what else do I need to add?

If I click on the filter by form button on the toolbar, I get 1 of 17
records and if there is nothing in a certain field (the chart location
field) those records are the 17 showing.

Thanks,

Linda

Ken Snell said:
Sounds as if the form's DataEntry property has been set to Yes. You
Click to expand...
need
to
reset it back to No.

--

Ken Snell
<MS ACCESS MVP>

Hi Everyone,

I have a form that I want to show all the records. Usually I have a
Click to expand...
1
of
3333 and can scroll through the list of patients using the record
selectors.
It was working until I moved the database to another drive and then back
to
the original location. Now when I open up the form, the record selector
is
at 1 an any new records I enter show up until I close it and then
Click to expand...
they
are
hidden again.

Access 2000


Thanks,
Linda
Click to expand...
Click to expand...
Click to expand...
 
Back
Top