Form and subform don't work together. (1 Viewer)

[paul young]

I created a function booking form with a subform to put down a list of food ordered. I cannot get each form to have its own list of food ordered via the subform. It merely copy each subform list for each record of form. I am going round and round trying to figure out what I have went wrong in the relationships arrangement. Have I missed something really obvious?

Help!!!

Paul

 

[Pat Hartman]

I didn't look at your db so I'm guessing but I would check the master/child links. To do this, open the mainform and click on the subform control. Then look at the properties. Set them if necessary.

 

[suepowell]

Hi,

I agree with Pat, I have just had a look at your database, and you don't have anything set in the link child fields / link master fields properties of your subform.

You need to enter the field names of the fields that links the master and subform in these properties.

If you create the subform using the wizard you are prompted to enter these values, so you could redo the subform and find the valus and format to enter that way.

Sue