Combo Box problem

T

Tony Williams

I have a combo control on a form that has when I select a value the form
reverts to the first record it doesn't stay with the current record. I have
a NotinList procedure that opens another form to enable the user to add to
the list of values in the combo control and when I close this second form
the new value is recorded but again the form goes to the first record and
doesn't stay with the current one. Anyone any ideas where I can start
looking for the reason why this happens?
Thanks
Tony
 
T

Tony Williams

Hi Rick, yes I'm using requery in the afterupdate event of the combo
control. However I can't think why now????
Tony
 
T

Tony Williams

Sorry Rick I know why I'm using requery. I have a tabcontrol and use the
requery command to populate Dlookup controls on the tabcontrol based on the
value in the combo control. Any other way round this?
Thanks
Tony
 
R

Rick Brandt

Tony said:
Sorry Rick I know why I'm using requery. I have a tabcontrol and use
the requery command to populate Dlookup controls on the tabcontrol
based on the value in the combo control. Any other way round this?
Click to expand...

Use Refresh or Recalc instead. Or you can issue Requery on those specific
controls instead of on the form.
 
T

Tony Williams

Hi Rick I can't find Refresh or Recalc in the list of Docmd options. How do
I refresh my tabcontrol?
Thanks
Tony
 
Top