Updating Subform

[Rich1968]

On my Main form I have a drop down box with catagory's that can change for the current record.

I want to be able to use this to update the catagory in the Sub form records. There may be 1 to 6 subform records that relate to the main form.

Any suggestions?

Rich De Gray

 

[Jack Cowley]

If your tables are set up correctly there is no need to save the Category in two tables. If Categories is your Master/Child link then set the Master link to the combo box.

hth,
Jack