Form with 2 subforms without a wizard

[Tom K via AccessMonster.com]

I cant use the form wizard because of user permissions. (The Man has total
control over my computer) But, I need to make a form with 2 subforms. The
wizard lets you use 3 data sources and makes a form with a main form and 2
subforms very easily. I cant figure out how to do it without the wizard. I am
using 3 tables with one to many relationships. They are address, business,
and inspections. How can I set these up so that address is the main form,
business has a one to many with address, and inspections has a one to many
with business?

Thanks

 

[[MVP] S.Clark]

Create the Main and Sub1 with the wizard. Create sub2 by itself. Drag and
drop, from the dbwindow, Sub 2, onto Main.

 

[Tom K via AccessMonster.com]

Thanks, but I cant use the wizard. I need to do it without any wizards.
Tom

Create the Main and Sub1 with the wizard. Create sub2 by itself. Drag and
drop, from the dbwindow, Sub 2, onto Main.

I cant use the form wizard because of user permissions. (The Man has total
control over my computer) But, I need to make a form with 2 subforms. The

[quoted text clipped - 7 lines]

Thanks

 

[Joan Wild]

Create your main form manually.
Create your subform manually.
Create your sub-subform manually.

Do you want a main form with two separate subforms (linked properly) or a
mainform containing a subform, which in turn contains a subform?



--
Joan Wild
Microsoft Access MVP

Thanks, but I cant use the wizard. I need to do it without any
wizards. Tom

Create the Main and Sub1 with the wizard. Create sub2 by itself.
Drag and drop, from the dbwindow, Sub 2, onto Main.

I cant use the form wizard because of user permissions. (The Man
has total control over my computer) But, I need to make a form with
2 subforms. The

[quoted text clipped - 7 lines]

Thanks

 

[Tom K via AccessMonster.com]

A main form with two separate subforms (linked propertly). Linked with the
main form and a first subform, linked one to many, and a second subform
linked one to many with the first subform.

The links are what Im finding difficult.

Thanks Tom

Create your main form manually.
Create your subform manually.
Create your sub-subform manually.

Do you want a main form with two separate subforms (linked properly) or a
mainform containing a subform, which in turn contains a subform?

Thanks, but I cant use the wizard. I need to do it without any
wizards. Tom

[quoted text clipped - 8 lines]

 

[Joan Wild]

Open the MainForm (address) and restore it so that you can see the database
window. Drag subform1 (business) onto your MainForm. Set the link
master/child properties accordingly (maybe AddressID and AddressID).

Put a textbox on the main form, call it txtLink and set its control source
to
=[subform1].[Form]![PrimaryKeyID]
For subform1 substitute the name of the control that contains your subform1
For PrimaryKeyID substitute your primary key for the recordsource for
subform1 (I'm guessing it's businessID or something)

Now drag subform2 from the database window on to your Main Form. Set the
link master property to txtLink and the link child property to the foreign
key field in subform2 that relates to subform1 (I'm guessing BusinessID)

You likely would want to set the default format for subform1 and subform2 to
datasheet, but that's up to you.
--
Joan Wild
Microsoft Access MVP

A main form with two separate subforms (linked propertly). Linked
with the main form and a first subform, linked one to many, and a
second subform linked one to many with the first subform.

The links are what Im finding difficult.

Thanks Tom

Create your main form manually.
Create your subform manually.
Create your sub-subform manually.

Do you want a main form with two separate subforms (linked properly)
or a mainform containing a subform, which in turn contains a subform?

Thanks, but I cant use the wizard. I need to do it without any
wizards. Tom

[quoted text clipped - 8 lines]

Thanks

 

[Tom K via AccessMonster.com]

Thank you very much!

Tom