Create my own Split form ?

[ECEK]

I've just forgotten how to do this:

Form1 is a blank formto hold the other forms

Form2 is Table1 in datasheet view

Form3 is Table1 in single form view

Form4 is Table2 in datasheet view

Data link is "ID"

I just want to click on Form2 (in datasheet view) and the other forms link up.

Thanks you lovely people !!

 

[Minty]

In the On_Current event in Form2 set a unbound hidden txtbox in Form1 to the value of "ID". Link all others forms to the unbound txtbox in Form1.

 

[ECEK]

Thanks for the response.
I have attached an unbound text box onto Form1 but that comes up with #Name?

I'm afraid I need a little more concise instruction based on my criteria.

I have dragged Form2 onto Form1
then created an unbound textbox renamed IDCall
then typed =[Form2].[Form]![ID]
then dragged Form3 onto Form1 and changed the Link Master Fields to IDCall and the Link Child Fields to ID
All to no avail but you may be able to understand where Im going wrong.

 

[CJ_London]

sounds like you have followed Minty's instructions to a T

only thing I can see potentially wrong is

=[Form2].[Form]![ID]

try

=[Form2].[Form].[ID]

the ! means access is looking for a control called ID, the . means it looks for a field called ID

Or try using the expression builder to navigate to the right field/control

And of course assumes your ID in form3 is the foreign key to the ID primary key in form2

 

[Minty]

IDCall then typed =[Form2].[Form]![ID]

This bit is wrong. Remove =.. from its control source and leave it blank.
On Form 2 you need to you need to go to design mode and in the Event properties tab click on the On_Current property. Select [Event Procedure] and then type the following;

Me.Parent.CallID = Me.ID

What this is doing is every time Form 2 record changes it will update Form 1 CallID,

 

[CJ_London]

This bit is wrong. Remove =.. from its control source and leave it blank.

Actually it does work, no code required

 

[ECEK]

Thanks guys brilliant stuff.

There was no need to use the VBA. (Although your instructions created a error)

The text that I used in the unbound CallID text box was:

=[Form2].[Form].[ID]

Also Note that I typed CallID into the Master links and ID into the child links of Form3 and Form4