Frustrating subform

[Mark-BES]

Hi,

I have looked through every book I have and spent hours on this but just cant get it right.

On the "menu" tab, select a customer then go to the "Calls" tab. Within the top subform is the list of telephone calls. In the below subform is the detail of the calls taken.

The problem: When I select a call, the details does not update in the form below.

Anyone willing to take a quick look? many thanks in advance.

Attached db1 (A97)

 

[RuralGuy]

Hi Mark,

You had the second SubForm linked with the CustID also. I changed it so the lower SubForm is linked by the CallID of the upper SubForm.

I had to convert to 2K to work on it then back to 97 so you can use it. I hope it works for you.

 

[Mark-BES]

RuralGuy, you are indeed a star and a gentleman.

It one of those things, you look at something for too long and all goes blured. Sometimes all it needs is a fresh pair of eyes.

Many thanks for your help.

 

[RuralGuy]

Glad to be of assistance.

 

[MStef]

Hello Mark!

I think it's a little beter now.
You don't need "frmCallDetailsSubform".