Continous subform acting like datsheet view

[Joe Miller]

Hi,

Given the difficuties outlined in previous posts about using datasheet view
as a subform, the consensus seems to be to use a continous form to act in a
similar way to a datasheet. However, there are one or two features of the
datsheet view that I'd like to be able to accomplish in the continous form
view that I'm not sure how to do:

1) I'd like the field widths to be adjustable by the user as they are in the
datasheet view.

2) I'd like the user to be able to highlight a record single by clicking
anywhere in the row it appears on (once highlighted I want data from the
record to then be available to a VBA proceedure executed when a user clicks a
button to call up a form with data from that record)

Can anyone help?
Joe Miller

 

[Brian]

I don't know of any way to do #1, but #2 is inherent. Once the user selects
any field of a record, that record becomes the current record, and you can
just use a reference to the name of any of the controls (probably text boxes)
as a reference to the value of the field bound to the control for that record.

 

[Joe Miller]

Thanks for that - I got there in the end with #2 but I'm wondering about the
feasability of doing this the other way around with a datasheet. See my
subsequent question if you fancy a pop at answering the specifics of that!

Joe