Updating form name into a subform

[Battlescar]

Hi
When I update a form Name(SurveyName) in he main form. I want it also update the Subform with the same name.


I have attached a few pics of what I am trying to do. So if I rename the SurveyName in the mainform from Test1 to Test3. I want it to update the Subform Names to Test 3. For those records with the same SurveyListID_FK And update all the records with the same name in the table EQSurveyListSubform as well.

[ranman256]

run an update query ,using the query in the subform.
update to the item changed in the main form.

If the subform query is qsSubformData
then your update query would be:
update [qsSubformData] set qsSubformData.[field] = forms!MainForm!txtBox

if the item you are changing is the key, (bound to the subform)
then no query is needed. alterning the master key will alter the subform keys automatically. (if you set relationships correctly)

[CJ_London]

When I update a form Name(SurveyName) in he main form. I want it also update the Subform with the same name.

this is bad practice, data should only be stored once - in this case in your tblsurveylist table.

You are already storing the FK, so all you need in your surveyyears form is a combobox, bound to the surveylistID_FK with a rowsource of

SELECT SurveyListPK, surveyName FROM tblsurveylist

Hide the first column so you will see the SurveyName, and lock the control so it cannot be changed from the subform

If you change the name in the mainform, just requery the subform to refresh the data being viewed

[Battlescar]

run an update query ,using the query in the subform.
update to the item changed in the main form.

If the subform query is qsSubformData
then your update query would be:
update [qsSubformData] set qsSubformData.[field] = forms!MainForm!txtBox

if the item you are changing is the key, (bound to the subform)
then no query is needed. alterning the master key will alter the subform keys automatically. (if you set relationships correctly)

So I took your advice and just created an update query. Works for me. Thanks.