Table <> form in datasheet view

[Georges Heinesch]

Hi:

I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).

Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts the datasheet view for table 2.

Is there no way to show 2 linked tables in a form in datasheet view
(with the "+" at the left of every record)?

TIA

--
Georges

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In main form's Design view on the Form's Properties dialog box, Format
tab:

(Access 97 & before) Set "Form View" to Datasheet

(Access 2000 & after) Set "Allow Form View" to No and "Allow Datasheet
View" to Yes.

HTH,

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP/zbpIechKqOuFEgE QI+JQCgnoHWklI4 BOZKbTAWymI5jQ3 klMEAn0/8
lUdHuDUSIvY9Eur dXomKcrfr
=cfgI
-----END PGP SIGNATURE-----
Georges Heinesch wrote:

Hi:

I have a tables in relationship to each other. When I open the main
table (table 1), I see a "+" at the very left of every record. Clicking
on the "+" expands the data of the linked table (table 2).

Now ... when I create a form from table 1, I didn't manage show these 2
tables the same way (with the "+" at the left side of every record) as
it was shown as table. Access insists of making a regular form out of
table 1, but accepts the datasheet view for table 2.

Is there no way to show 2 linked tables in a form in datasheet view
(with the "+" at the left of every record)?

TIA

[Georges Heinesch]

MGFoster wrote:

In main form's Design view on the Form's Properties dialog box, Format
tab:

(Access 97 & before) Set "Form View" to Datasheet

(Access 2000 & after) Set "Allow Form View" to No and "Allow Datasheet
View" to Yes.

In fact, the "Allow DataSheet View" was selected, but I didn't look that
far. I used the wizard to create the form + subform, and the wizard
doesn't offer the possibility of the main form being in datasheet view.
Hence I concluded (by mistake) that the datasheet view would not be
possible with forms having subforms.

Thanks for the hint!

--
Georges