dependent combo boxes in datahseet view

[BBC via AccessMonster.com]

I have a sub-form with records shown in datasheet view. How do I code
dependent comboxes within the records in this view. I know how to do it
using combo boxes on a form using VBA but not sure how to duplicate that
method on the datasheet (given can't get at "events" and the multiple lines
of code required in VBA, [SQL, .Requery, ...] )
thanks
Brian

 

[John W. Vinson]

I have a sub-form with records shown in datasheet view. How do I code
dependent comboxes within the records in this view. I know how to do it
using combo boxes on a form using VBA but not sure how to duplicate that
method on the datasheet (given can't get at "events" and the multiple lines
of code required in VBA, [SQL, .Requery, ...] )
thanks
Brian

AFAIK you can't. I'd suggest using a Continuous Form instead - it can be made
to look very like a datasheet if that's the image you want, but is much more
programmable.

 

[BBC via AccessMonster.com]

Thanks. (what does AFAIK mean)
I currently have 8 datasheets (child tables) on the Form, each on the TAB of
a TAB CONTROL so the "look" is pretty much set. Have not used continuus
forms before so will need to do some research to see if I can make it look
and work close enough. Any other thoughts or comments?
thanks again
Brian

I have a sub-form with records shown in datasheet view. How do I code
dependent comboxes within the records in this view. I know how to do it

[quoted text clipped - 3 lines]

thanks
Brian

AFAIK you can't. I'd suggest using a Continuous Form instead - it can be made
to look very like a datasheet if that's the image you want, but is much more
programmable.

 

[Linq Adams via AccessMonster.com]

"AFAIK" means As Far As I Know, and when said by John, pretty much means NO
in this case.

 

[John W. Vinson]

Thanks. (what does AFAIK mean)

As far as I know, it means "as far as I know". (Hey, I don't always eschew
redundancy).

I currently have 8 datasheets (child tables) on the Form, each on the TAB of
a TAB CONTROL so the "look" is pretty much set. Have not used continuus
forms before so will need to do some research to see if I can make it look
and work close enough. Any other thoughts or comments?
thanks again
Brian

You can design a continuous form with textboxes (or combos or other controls)
dragged up to the very top of the detail window, and jammed together with no
gaps between. Put labels for the fieldnames in the Form Header, and suppress
the form footer. Drag the bottom of the detail section up to the bottom of the
textboxes, and the form will look very much like a datasheet. The user won't
be able to shrink or expand the columns as they can in a datasheet, it's
arguable whether that's a benefit or a detriment!

 

[BBC via AccessMonster.com]

Thanks, I'll give this a try. These particular datasheets are only a few
columns so don't really need to be resizable - so this may be practical...
thanks much