Table grid on a dialog

[Gord]

Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord

[Tom van Stiphout]

On Fri, 10 Oct 2008 17:54:34 GMT, "Gord" <x1******@telus.netwrote:

How about a subform in datasheet view?

-Tom.
Microsoft Access MVP

>Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord

[Gord]

Thanks Tom. I think that's going to work just about perfect.

I have a little experience with VB6 and am teaching myself Access 07. I'm
going to need to know (programmatically) what record/field the user is
editing in the subform datasheet so as to do some checks on data validation.
Any pointers/suggestions on how to do this would be helpful. I'll be using
a query as the 'Source Object' for the subform.

I've created record sets in code from tables and then done editing and
adding new records. In the case here I'm using a query created from design
view in Access so (I assume) Access has created some sort of record set
automatically. I would think that I need to access this record set to see
what's going on?

As I said, any pointers would be appreciated. I have a couple of books and
the on-line help to refer to if I can just get pointed in the right
direction.

Thanks,

Gord

"Tom van Stiphout" <to*************@cox.netwrote in message
news:js********************************@4ax.com...

On Fri, 10 Oct 2008 17:54:34 GMT, "Gord" <x1******@telus.netwrote:

How about a subform in datasheet view?

-Tom.
Microsoft Access MVP

>>Is it possible to get a table type grid to appear on a custom dialog form?
Basically, get the same thing as when you open a table in Datasheet view
and
can edit the individual columns. I'd like to make a custom dialog (free
floating without the tab) with some textual instructions and then have a
few
records displayed (probably from a query) in a little table that looks and
acts something like a table opened in Datasheet view.

The listbox control is close but doesn't allow the user to click in an
individual column and edit that data. Also, the listbox (as far as I
know)
doesn't automatically expand and shrink to accommodate the exact number of
rows to be displayed. I already know how to create a dialog form with
some
controls on it but I can't see how to make a little table appear.

Thanks,

Gord