Moving the record set

[Maracay]

Hi Guys,

I created a form to consult data from a query, I am not using the query
fields on the form, I am using text box and I move the data from the query to
the respective text box, what I want is to create a command button to move
the record set forward or backward to show another records. I created a
command button but always start in record 1, never move.

I’ll really appreciate if someone may give me a hand with this.

Thanks

 

[PieterLinden via AccessMonster.com]

Hi Guys,

I created a form to consult data from a query, I am not using the query
fields on the form, I am using text box and I move the data from the query to
the respective text box, what I want is to create a command button to move
the record set forward or backward to show another records. I created a
command button but always start in record 1, never move.

I’ll really appreciate if someone may give me a hand with this.

Thanks

If you want to be able to scroll through the records, you should bind the
form to the query. Just open the form in design mode and set the form's
recordsource to the query name. You can filter the records returned when you
call the open method of the form... Basically just build a valid WHERE clause
without the WHERE keyword at the front, and open the form. Then you can
scroll through the records. If you don't want the user to be able to edit or
delete any records, you can open the form as read only.