Buttons and subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EAB1977 - 17 Jul 2007 14:02 GMT

Hi guys,

I have a little problem I am hoping someome has experience in. I have
a subform that is formatted in datasheet view on my form that so that
a user can see the data that is being entered in through the form. I
need some buttons on my form so the user can go to the end of the
datasheet on the subform, page up, page down, etc, but I am unsure how
to do it or to what the code would look like. I would appreciate any
help.

Reply to this Message

Klatuu - 17 Jul 2007 15:34 GMT

You can either expose and use Access navigation or you will need a subform
with a subform. A form in datasheet or continuous view can't have anything
except the data and the form controls available through Access.

Signature

Dave Hargis, Microsoft Access MVP

> Hi guys,
>
[quoted text clipped - 5 lines]
> to do it or to what the code would look like. I would appreciate any
> help.

Reply to this Message

Paterson - 17 Jul 2007 18:00 GMT

If you create a tabular style subform, you can format the text boxes to use
up all the space in the data field, so it will appear like a datasheet. Then
you could use the form header to put the headers of your fields and place
buttons for navigation. The command button wizard should take you through
making the code.

> You can either expose and use Access navigation or you will need a subform
> with a subform. A form in datasheet or continuous view can't have anything
[quoted text clipped - 9 lines]
> > to do it or to what the code would look like. I would appreciate any
> > help.

Reply to this Message