update data on form

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello,

I have a form A that shows different data. If I want to change data I open a
form B by clicking a button. When I close form B, I don't get to see the
changes I made. I tried the DoCmd.Refresh with several events (Before
Update, On Got Focus, ...) but nothing works. What am I doing wrong?

Thanks for any help.

Chris
 
-----Original Message-----
Hello,

I have a form A that shows different data. If I want to change data I open a
form B by clicking a button. When I close form B, I don't get to see the
changes I made. I tried the DoCmd.Refresh with several events (Before
Update, On Got Focus, ...) but nothing works. What am I doing wrong?

Thanks for any help.

Chris


.
Click to expand...
You have to refresh the control! Like cboResults.requery
not the form itself
 
Dan,
I think the problem is a bit more complex. In fact I have two forms (A and
B) that both contain a subform. On form A I choose by means of a combobox
the records that need to appear in the subform (combobox contains list of
product numbers, subform shows composition of product on continuous form).
Now I would like by clicking a button to open form B so I can make changes
in the composition. Form B also contains a combobox with the product numbers
(because I'm using it also seperately) and a continuous subform for the
articles. After closing form B I would like to see the changes I made in
form A.
Is there a way to do this and also avoiding to have to use the combobox each
time I change forms.
When trying to explain this I noticed that there's something odd happening
with the sorting in the subforms. When I make a change in the composition in
form B the order of the articles has changed when I open form A. When I
close form A and open form B again, I also get the changed order there. What
is happening here???

Thanks in advance for any help with this.

Chris
 
Back
Top