One Main Form and 2 subforms

[GRIFFIJ]

I have 1 Main table and 2 subforms as below:

Table 1

Client_Details

PK ClientIDNo
DOB
ClientSurname
ClientFirst
ClientTitle

Table 2

Client addresss_details

PK ClientAddressID
PK ClientIDNo
ClientAddressPropertyName
ClientAddressFlatNumber
ClientAddress
ClentAddressTown
ClientAddressCity
ClientAddressCounty
ClientAddressPostalCode

Table 3

Client_Contact_Details

PKClientContactID
PK ClientIDNo
ClientHomePhoneNo
ClientMobilePhone
ClientEmailAddress


Table Layout

From the Client_Info table I have 2 1 to many lines coming from PK ClientIDNo to the same on the other tables

I have been advised to use subforms. Now I know how to create 1 subform from a main form unsure how to make more than that.

I am wanting also to create the as linke but a button rather than veing bound to that form

 

[TheAceMan1]

GRIFFIJ . . . .

In design view of the mainform click the [blue]Subform toolbar button[/blue]

, then click any [blue]blank area[/blue] in the details section and follow the wizard from there.

See Ya! . . . . . .

 

[GRIFFIJ]

Hi thanks for the advice. I want all subforms to look like Norm forms that you access with a comand button rather than it be embedded on the master form

 

[TheAceMan1]

OK GRIFFIJ . . . . .

Subforms are always embedded. For what you want [blue]you'll have to open them as standard (non-embedded) forms[/blue]. They simply [blue]need to be synchronized to the PK[/blue] of the mainform. [purple]To do this, base the RecordSource of the forms on a query which includes the linking PK to the mainform and has criteria for the PK of:[/purple]

[blue]   Forms!MainFormName!PKname[/blue]

Depending on how much realestate is used by the mainform, you may get into alot of positioning of the forms before you finally get it right . . .

See Ya! . . . . . .