Data shown in screen suddenly become lesser

[cheer]

Attached below are 3 JPEG files illustrate how the problem happen

Before.jpg - show the original screen

Process.jpg - show the activity I am doing. I choose No when the message box prompt out

After.jpg - show the output in screen immediately after I click No

My question is the data shown in screen suddenly become lesser . Any reason and what could be the solution ?

 

[gemma-the-husky]

the total is still the same

scroll right, and you will see a scroll bar
scroll back up, and you will be able to see trhe "missing" item
(or move up through the records with cursor keys)

 

[cheer]

the total is still the same

scroll right, and you will see a scroll bar
scroll back up, and you will be able to see trhe "missing" item
(or move up through the records with cursor keys)

already scroll up, can't move further up ...

 

[gemma-the-husky]

perhaps you don't have a vertical scroll bar in the subform - continuous form. The total hasn't changed, so the records must be there.

 

[vbaInet]

Like gemma-the-husky said, scroll right then scroll up.

Edit: Just noticed there was an update before mine.

 

[MStef]

I suggest, put Event on "After del confirm",
and put the code

DoCmd.GoToRecord , , acFirst

in that sub.

 

[cheer]

Like gemma-the-husky said, scroll right then scroll up.

Edit: Just noticed there was an update before mine.

Has followed what has been proposed, but it doesn't work. Look at the attachment below

 

[cheer]

perhaps you don't have a vertical scroll bar in the subform - continuous form. The total hasn't changed, so the records must be there.

Form come with scroll bars turn on BOTH. Look at the attachment below

 

[cheer]

I suggest, put Event on "After del confirm",
and put the code

DoCmd.GoToRecord , , acFirst

in that sub.

TQ, it works !!! The command above will move cursor to the first record and all records can be displayed on screen now.

 

[vbaInet]

You're using a subform that has the scrollbars (both vertical and horizontal) turned off.