How to Change Field with a Combo Box Twice

[Wooden_Shoes]

Hello,

I am trying to change two fields with the same form using a combo box. When I change the record (serial number) in the field using a combo box, it automatically updates the records in the other fields (which is what I want), but it also changes the field (serial number - installed) and it's associated records/fields, which i do not want it to do. I would like to be able to change these records separately on one form and then click my 'save' button and move on to my next change out. I have included a picture to show what I want my form to look like. Is this where a sub form would be used???

Any help would be greatly appreciated.

Thanks,

Greg

[June7]

Looks to me like you have two sets of controls bound to the same fields. This means they are displaying the same record. So any edit on either side is editing the same record.

You want to change the status of substation from installed to removed or vice versa? You could just change a status field. However, if you want a history of these changes then yes, will need a dependent child table to document these transactions.

[Wooden_Shoes]

Looks to me like you have two sets of controls bound to the same fields. This means they are displaying the same record. So any edit on either side is editing the same record.

You want to change the status of substation from installed to removed or vice versa? You could just change a status field. However, if you want a history of these changes then yes, will need a dependent child table to document these transactions.

Yes I want to be able to choose a device based upon the its Serial Number, then update its Substation, Location, Date Installed, etc....I want to do this for two records at a time since we will be replacing one device with the other. All of these records are in one table. You can ignore the "Installed" and "Removed" headings, i forgot to take those off.

Thanks,

Greg

[June7]

You must edit one record then find the other record and edit it.

The two sets of controls on one form will not accomplish this.

A combobox used to input search criteria must be unbound (no ControlSource). Review http://datapigtechnologies.com/flash...tomfilter.html