Hi,

I'm trying to use this code OnOpen event:



And I get error: You can't assign a value to this object.

cboName is Bound
txtName is Unbound

When I try this:


ComboBox value is ok, but Record is not added when I close/save record.
And when I pick value from Combobox and save, record it is added.

Since I need this combobox disabled, users will not be able to pick value.

Thanks in advance.

First question. Why are you trying to do it this way?

Hi,

I want users pick values from one form and open another form filled with that values.

There are two buttons, one for Add new record and another for Changing existing record, both based on 3 Combobox criteria.

When u fill Combos and click Change button, and if record based on that values is not exists there is a message that record doesnt exist.
Also if you try to add new record and record is exist, there is a message that record based on that values exists.

Hope you got me.

It sounds like you don't have your tables setup correctly and normalized. You should not need to do all this. You really only nees a main form and a sub-form, which would show records for the corresponding value in the main form. Could you provide a little background on your database? Such as what is it for? eg. track customers and orders, etc.