Subform not being refreshed -- why?

P

plh

Access 2000:
I have a database containing a parent form with a sub form. There are combo
boxes on the sub form that have double click events which retrieve values form
other forms and plug them in to the combo box. After having done this, the new
values fail to appear in the sub form within parent form. Using the standard
methods of refresh (Clicking Records > Refresh or setting up refresh buttons on
the parent or on the sub form) does not help.

HOWEVER, if I move to the previous (or next) parent form record, then back,
there they are, appearing as if by magic!

How can I get them to appear without having to change parent form records?

More information which may or may not be helpful:
The reason I am using the double click events rather than just the list that
drops down from the combo boxes is that the number of choices are large and
growing, and opening a form allows for the list to be filtered, reordered, etc.
for easy selection. The numeric primary keys are passed around among the forms,
so the combo box allows an easy way to display a descriptive value.
Thanx,
plh
 
R

RuralGuy

Try Requery instead of Refresh.

Access 2000:
I have a database containing a parent form with a sub form. There are combo
boxes on the sub form that have double click events which retrieve values form
other forms and plug them in to the combo box. After having done this, the new
values fail to appear in the sub form within parent form. Using the standard
methods of refresh (Clicking Records > Refresh or setting up refresh buttons on
the parent or on the sub form) does not help.

HOWEVER, if I move to the previous (or next) parent form record, then back,
there they are, appearing as if by magic!

How can I get them to appear without having to change parent form records?

More information which may or may not be helpful:
The reason I am using the double click events rather than just the list that
drops down from the combo boxes is that the number of choices are large and
growing, and opening a form allows for the list to be filtered, reordered, etc.
for easy selection. The numeric primary keys are passed around among the forms,
so the combo box allows an easy way to display a descriptive value.
Thanx,
plh
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
P

plh

Try Requery instead of Refresh.
Click to expand...

That did not help, if the information is new. I have to close then open the main
form in order to get the new information to show up.
Thank You,
-plh
 
R

RuralGuy

If you are doing the Requery correctly than your symptom indicates the record
has not been saved yet. Try saving the record first.

That did not help, if the information is new. I have to close then open the main
form in order to get the new information to show up.
Thank You,
-plh
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
P

plh

If you are doing the Requery correctly than your symptom indicates the record
has not been saved yet. Try saving the record first.
Click to expand...

I really do appreciate your replies.
The record is saved as indicated by the little pencil turning into a triangle.
I am going to start a new thread on this because I don't think I explained it
well enough the first time. The title will be "Problems getting subform to show
new data."
Thanx,
-plh
 
Top