Subform links

[jaydeebe]

I have a subform that autotakes a value from the master form in a linked field. I would like that same subform to autotake another value from a control that is taken from a combobox (different table to what the master form is based on so it can't be linked as master/child). How can i do this.

Jaydeebe BSC (hons) MCP

 

[MaxEd]

Use Forms!MainForm![combobox] in the subform as the control source.

 

[jaydeebe]

Doh! Of course, thanks that works fine!

Jaydeebe BSC (hons) MCP

 

[jaydeebe]

Actually it doesn't work. I want to save the record but now that field is not linked to the table. How can I do this. I want the value to be saved to a particular field in a table.

Jaydeebe BSC (hons) MCP

 

[jaydeebe]

Revision - I have 4 tabs. the first three tabs ask the user for input. This input is then drawn together on the final tab for viewing and comformation. I want this info to be saved as a record in a table upon comformation. How can i pass these values to the table?

Jaydeebe BSC (hons) MCP

 

[MaxEd]

jaydeebe,
Since you have the main form linked to the subform already by the same parent/child relationship, why do you need to save those values to a table? Aren't you duplicating the data if you are having to save that to the table in the subform?