Form and Subform links

[Carrie]

Hi



I have a form and subform on Microsoft 97. The link is the job number. I have linked this up on the master and child links and every is fine. When I input data onto the subform the jobno automatically populates.

However I've had to export this form into Microsoft 2000. Although the link is still there it no longer automatically populated the job no into the subform.

I don't understand why it works in 97 and not 2000.
Have recreated the form and subform and it still does not work. The only thing I can think of is that the subform is based on a query and it doesn't like it?

Can anyone help?? It would be most appreciated!!!

Thanks
Carrie

 

[WayneRyan]

carrie,

I use mostly 97 myself, but what I would do is on your
subform, make the jobid's default value:

Form!Main!ParentID

and set Enabled = False. This will at least be a work-around
until you can research why A2K behaves as it does.

Wayne

 

[Carrie]

Links of child and master

Thanks for the advice!

I did work it out eventually last night!!! It was because my control source and name properties were the same on the subform field being linked to the main form. When I made the name property different to the control source it worked!