Not showing all records

[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

 

[Ken Snell]

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

 

[LMB]

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]

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>

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

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

 

[LMB]

It worked!

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>

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

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>

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