Datasheet View

[Guest]

Wanted to know if there would be a way to pull off having a datasheet view
but right above the columns having another field that the user can select.

For example:
Date: (Row) Data ---> ( Over each of the Column Headings)
Medications Change1 Change2 Change3 (Column Heading)
Data Data Data Data
| | | |
V V V V

Does anyone know how I can pull this off in one datasheet?

Thanks for your help, Happy 4th of July!

 

[Pat Hartman\(MVP\)]

Not in a datasheet itself. You can try putting the datasheet on a main form
and putting the selectable fields on the main form positioned above the
columns of the datasheet. This will be hard to get to look right plus you
have to make sure that the datasheet columns don't resize since that would
throw everything off.

 

[Guest]

Besides positioning above the element, can you think of anything else that I
can do to achieve this?

Thanks, Ryan

 

[Ron2006]

If your table record was defined as


medication
Chng1 data
chng1 flag
chng2 data
chng2 flag
etc.

have the datasheet show

medication change1 chnge2 chng3

With instructions to <Dbl-Click> the chng value that you want to modify

On the dbl-click event toggle the assocated change flag

On the datasheet form put in conditional formating to change the color
of any of the items that have chngn = true.



Ron