Discussion Groups Home

3 tiered form with datasheets? in Access Database Forms

8/9/2004 1:38 PM PST

Question

I have a Parent form of customers (Form1) with 2 sub forms. Form2 is products
for customers, and Form3 is info for products. I want Form2 and Form3 to be
datasheets.

So, you navigate to the customer, Form2 changes to show their products. You
navigate Form2 and Form3 changes to show the info for the products.

I would have put Form3 into Form2, but that won't work cause they need to be
datasheets. I want some way to get Form2 to change Form3 on navigation.

Was this post helpful to you?

Top

Arvin Meyer

8/9/2004 8:58 PM PST

Answer

Take a look at the Customer Orders form in the Northwind sample database
that comes with Access. It has an example of 2 datasheet subforms and a
mainform which all sync the way you wish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"M K" <mark@nospamcenturycolor.com> wrote in message
news:EDFE7A33-9EEE-470B-990D-6A3DBEC37F47@microsoft.com...
> I have a Parent form of customers (Form1) with 2 sub forms. Form2 is
products
> for customers, and Form3 is info for products. I want Form2 and Form3 to
be
> datasheets.
>
> So, you navigate to the customer, Form2 changes to show their products.
You
> navigate Form2 and Form3 changes to show the info for the products.
>
> I would have put Form3 into Form2, but that won't work cause they need to
be
> datasheets. I want some way to get Form2 to change Form3 on navigation.

Was this post helpful to you?

Top

M K

8/10/2004 5:22 AM PST

I was hoping I wouldn't have to go there, but thanks... it did answer my
question. (I didn't think I had it installed... Northwind that is. But I do,
or do now...)

"Arvin Meyer" wrote:

> Take a look at the Customer Orders form in the Northwind sample database
> that comes with Access. It has an example of 2 datasheet subforms and a
> mainform which all sync the way you wish.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "M K" <mark@nospamcenturycolor.com> wrote in message
> news:EDFE7A33-9EEE-470B-990D-6A3DBEC37F47@microsoft.com...
> > I have a Parent form of customers (Form1) with 2 sub forms. Form2 is
> products
> > for customers, and Form3 is info for products. I want Form2 and Form3 to
> be
> > datasheets.
> >
> > So, you navigate to the customer, Form2 changes to show their products.
> You
> > navigate Form2 and Form3 changes to show the info for the products.
> >
> > I would have put Form3 into Form2, but that won't work cause they need to
> be
> > datasheets. I want some way to get Form2 to change Form3 on navigation.
>
>
>

Was this post helpful to you?

Top

	Return to Microsoft Communities		Notify me of replies