Subform update after changing field on parent form

[jhergert]

I’m hitting a road block. I have a form with a subform. I would like the subform to change along with a combo box change on the parent form. Right now when I go to change from one record to another I get an error message.

I know I’ll have to probably provide more information.



Thank you in advance

[Edgar]

Getting an error when you go from one record to another means you have code reacting to that record change. Show the code where the error is.

If you want the subform to change after changing a combobox on the parent form, that's usually a Requery that you need to trigger on the combo box after update event.

[mike60smart]

Can you show the code in the AfterUpdate of the Combobox?

[jhergert]

I don't have any code on the after update event for the combo box

[jhergert]

Sorry, error was probably not the best thing to say. The message i get is= The record cannot be deleted or change because the table included related record.

[Edgar]

Your combobox is not properly configured. Post a sample database.

[jhergert]

I think i have it attached. Let me know if it isn't there

The form I am working in is the StructureAssembly form.

Thank you for your help

[Welshgasman]

I’m hitting a road block. I have a form with a subform. I would like the subform to change along with a combo box change on the parent form. Right now when I go to change from one record to another I get an error message.

I know I’ll have to probably provide more information.

Thank you in advance

Never mind

[mike60smart]

Hi J

It is all down to construction of tables.

Each table should have its own Autonumber to uniquely identify records.

You are assigning an automumber named "ID" but not setting it as an Autonumber.

You are using text dataType as an Autonumber.

Look at the Relationship Diagram and database attached so that you can work out where you are going wrong.

[Edgar]

It appears you're trying to go to another record with that combo box. However, when you modify it, you're trying to modify the primary key of that record. If you attempt that, you get that error, which is Access complaining that child records in your assembly table need that record, that primary key appears there and you're trying to modify it, that's why.

So, if you want to go to another record, use an unbound combo box and something that triggers the record change with it. Do not try to modify StructureCode, it is the primary key of your table.BOM Master Database Sample.zip

[jhergert]

Thank you everyone for your help. I pretty much opened the app and started watching videos on how to develop a database

[mike60smart]

Hi J
Here with an update to my last example.

The subform dealing with materials now works as it should.

Regards

Mike