Continous subform acting like datsheet view


G

Guest

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
 
Ad

Advertisements

G

Guest

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.
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top