Using a combobox "value" to copy whole record /create a new record...BUT

[MackMan]

Here's what I'm trying to do...

Let's say, I'm updating a record, and I have a combo-box that says transfer and another combo-box that states "where to?" - or words to those effect.

Each record has a field for credit value and a field for debit value.

What I'm having difficulty in doing is..

When I've finished entering the current record, I want to run code that fires the event, so, copies all the data from one record, to create a new record, BUT...

1) changes the "where to" from the old record to "From" in the new record.
2) changes either the credit or debit value, to the opposite in the new record?

I would like to do this from a sub-form.
I can copy a whole record, no problem, but can't seem to change field values.

Any help would be much appreciated.

 

[llkhoutx]

Re: Using a combobox "value" to copy whole record /create a new record...BUT

Add a button to your form which is click when data is entred and combo boxes are updated. On OnClick use ADO/DAO to append the modified record to the other table.

 

[MackMan]

Re: Using a combobox "value" to copy whole record /create a new record...BUT

Thanks for that. Didn't think of that method. Works a dream. Used the .visible = true on the combo box so it can't be clicked in error.