By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,437 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Table <> form in datasheet view

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBP/zbpIechKqOuFEgEQI+JQCgnoHWklI4BOZKbTAWymI5jQ3klMEA n0/8
lUdHuDUSIvY9EurdXomKcrfr
=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


Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.