Edit to subform making changes to main form on non-child field

[Seth Schrock]

I have a subform that has three fields that are titled the same as the main form, but two of them are for different things and the third is the Master/Child link field. However, when I change the SerialNumber field in the subform, it changes the SerialNumber field in the main form and vice versa. The SerialNumber field is not part of the master/child link so why the connection? There is nothing in any of the AfterUpdate events to make the change go across. I'm not sure where to look next.

[TheSmileyCoder]

I must admit to not being sure either, based on your description. Maybe if you describe the tables involved in both main form and sub form.

[Seth Schrock]

The table behind the parent form is for computers. The table behind the subform is for the monitors. Each table has a SerialNumber field and a PurchaseDate Field, but otherwise the fields are totally different. They also each have their own auto number field as the PK with the monitor table (tblMonitor) having the FK field as the PK of the computer table (tblDevices). Not sure if there is any other information that you would need. I used to use SerialNumber as the PK until I found some devices that didn't have a serial number. So I had to create an autonumber field to do be the PK.

[TheSmileyCoder]

Any chance your recordsource for the subform is a query in which you have selected the field from the main table and not the subtable by accident?

Its the only thing making sense based on what you information you have provided.

[Seth Schrock]

I did forget about the query in between the table and the form. And you were correct that it was pulling that field from the main form table not the subform table. Thanks so much. I was stumped.

[TheSmileyCoder]

Your welcome. Best of luck with your project!