M
Mercy
Hello,
I have a Form 1A and subform 1B which is based off of
Table 1B. There's a button on Form 1A which runs an
append Query which adds records to Table 1B. The problem
is that the subform doesn't update/refresh itself.
Is there a command I can do to make it refresh itself?
Along the same lines, I have a drop down list based off
of Table "Color", and I limited it to the values in the
table. So on "not in list" event I created another form
where the User will enter in the new color and run
another Append Query to update the Table "Color". The
problem is that the change is not immediately reflected
in the drop down list. Is it possible to have the change
immediately reflected?
Thanks in advance!
Mercy
I wanted to be able to add values to the list.
I have a Form 1A and subform 1B which is based off of
Table 1B. There's a button on Form 1A which runs an
append Query which adds records to Table 1B. The problem
is that the subform doesn't update/refresh itself.
Is there a command I can do to make it refresh itself?
Along the same lines, I have a drop down list based off
of Table "Color", and I limited it to the values in the
table. So on "not in list" event I created another form
where the User will enter in the new color and run
another Append Query to update the Table "Color". The
problem is that the change is not immediately reflected
in the drop down list. Is it possible to have the change
immediately reflected?
Thanks in advance!
Mercy
I wanted to be able to add values to the list.