Combo Box problem

  • Thread starter Thread starter Tony Williams
  • Start date Start date
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
 
Tony said:
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
Click to expand...

That is what happens when a form is Requeried. Are you issuing any Requery
commands on the form?
 
Hi Rick, yes I'm using requery in the afterupdate event of the combo
control. However I can't think why now????
Tony
 
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
 
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.
 
Hi Rick I can't find Refresh or Recalc in the list of Docmd options. How do
I refresh my tabcontrol?
Thanks
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
synchronized Combo Boxes in subforms 2
Macro doesn't work first time form is opened. 2
Combo Box Filter 1
Combo Box Problem 5
Combo Box Not Updating 2
2007 Multi Value Check Box Lists 1
Combo Box question 4

Back
Top