How to place inserted values from one field to another based on selected combo box values in a diffe

[mainman11]

I have created a combo box in a form. The user can select two options. If a specific option is selected, values earlier inserted in a specific field of a different form should be automatically removed there and inserted in the column which is selected in the other form. Does anybody know how to achieve this in MS Access? I am a total beginner at VBA code. Would it be an idea to create an event procedure on change where I update the fields in the first form based on the selection of the combo box?
I am using access 2010.

[kd2017]

Possible? Sure. Unusual? Yep.

Without seeing your db it will be hard to guide you on specifics.

Maybe if you could describe more overall what's going on we can help you better or even provide alternatives that might be more appropriate. Is the other from still open? Is this data from both forms saved to a table? Are these forms bound to tables? What if the user makes a mistake in the combobox? Are you building something like a wizard ui for your users?

[Micron]

Is the other (1st) form open at the time, but more importantly, is it bound (or at least are the fields that are to be edited bound)? If they are bound, there is no need to alter form field data - just update the table fields directly. I would also requery the 1st form from this code behind the 2nd form. However, I don't know what you mean by inserted into a column. Column of some combo (i.e. add it to its list) or is this about a datasheet column? In the latter case, seems like you want to update a table field to Null (as in the first part I mentioned) and update some other table field to that value. I find that to be a strange notion. Why would anyone move values around like this?

[Gicu]

Cross-post it here:https://www.access-programmers.co.uk...t-form.320860/