How to make command button page down

[pleasehelpalot]

I have a command button on a form which has a 'down' arrow symbol on it. When the user clicks on the button I want it to page down. In other words to make the 'on click' event the same as hitting the page down key. What is the code to make this happen?

 

[bubba100]

Take a look at SendKeys in the help.

 

[dhookom]

I would add code to set the focus to a control near the top of where you want to display.

Duane
Hook'D on Access
MS Access MVP

 

[pleasehelpalot]

I checked the sendkey instructions and they don't seem to be what I need. Set focus does not page correctly and leaves the screen out of order. I need to find a way to make the command button work as clicking the 'page down' key. I remember doing something like this in the past but lost the code. Page down works as needed.

 

[bubba100]

What happens with SendKeys "{PGDN}". What version of Access are you working in?

 

[MajP]

Sendkey should work fine. You probably need to set the focus to a text box if you want the records to scroll.

 

[pleasehelpalot]

This is new territory for me. Do you need to set up a Macro to use sendkey?

 

[MajP]

Something like

Private Sub Command7_Click()
'set focus first to text box
Me.EmployeeID.SetFocus
SendKeys "{PGDN}"
End Sub

 

[pleasehelpalot]

SendKeys "{PGDN}" worked perfect and simple too


Thanks