Refresh data on form

[Smoki]

Hi,
I have DB, and I made form for searching specific data. It's form where I
choose value from Unbound field, and then other fields have been filled. But
I want then to change value of some of those fields. So, I made Combo box to
choose new value for that field. Just I don't know which action to use now to
exchange value of this field?

Thanks,
Smoki

 

[Daryl S]

Smoki -

If you are using the new combo box to choose a value for a field on your
form, then as long as the new combo box is bound to the field from the
recordsource, then the field will update when the user selects the new value
from the combo box.

The combo box used to select a record should not be bound (which is how you
have described it), as you don't want to change the value of the field on a
current record, but instead use that value to pull up a record. To use a
combo box to change the value of a field, it does need to be bound to that
field.

Hope that helps.

 

[Smoki]

Smoki -

If you are using the new combo box to choose a value for a field on your
form, then as long as the new combo box is bound to the field from the
recordsource, then the field will update when the user selects the new value
from the combo box.

I know this what you write here, field will always has the value which I
choose in Combo box. And, if I change the value in Combo box, that field will
show that new value
But I want to put this new value which I choose in combo box, in other field
on my form, which is already filled (bound field which becomes filled, when I
choose value in other unbound combo box).

The combo box used to select a record should not be bound (which is how you
have described it), as you don't want to change the value of the field on a
current record, but instead use that value to pull up a record. To use a
combo box to change the value of a field, it does need to be bound to that
field.

That Combo box which I made is really unbound. I will explain what is all
about. It's equipment DB, and i want to change location of some swith, for
example. I find that switch by it's serial number (by using unbound combo
box), and then other fields on my form have been filled (it's bound fields,
it is from one row from table). Now I want to change only one paramether
about this switch, to change location. So made new unbound combo box, with
all possible location (there are in other table), then choose some of them.
And finally, what to do, how to exchange this location of this switch?! When
I search for this switch next time, I want to show me updated location, not
the old one. So, can I put some command button, and which? Which action to
implement here?!
I write a lot now, I hope I explained my problem better?!
Smoki

 

[Daryl S]

Smoki -

The combo box for the Location (which is a field you want to change on the
record) should be bound to the Location field on the form. This will cause
the newly selected Location to replace the original Location in the database.

 

[Smoki]

But, when I change and set the Control Source for my Combo box to Location
field on my form, then this Combo box always has the same value as Location
field, and I can't change this value to any other.
Control source of Combo box is =[Text36], and Text36 is field of Location.

Maybe I didn't do something good?

Smoki