 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Combo Box problem
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 > 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 [quoted text clipped - 5 lines] > happens? Thanks > Tony That is what happens when a form is Requeried. Are you issuing any Requery commands on the form?  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hi Rick, yes I'm using requery in the afterupdate event of the combo control. However I can't think why now???? Tony >> 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 [quoted text clipped - 8 lines] > That is what happens when a form is Requeried. Are you issuing any > Requery commands on the form? 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 >> 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 [quoted text clipped - 8 lines] > That is what happens when a form is Requeried. Are you issuing any > Requery commands on the form? > 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? Use Refresh or Recalc instead. Or you can issue Requery on those specific controls instead of on the form. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hi Rick I can't find Refresh or Recalc in the list of Docmd options. How do I refresh my tabcontrol? Thanks 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? > > Use Refresh or Recalc instead. Or you can issue Requery on those specific > controls instead of on the form. Sorry Rick found it in Help Me.Refresh Thanks for the pointer 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? > > Use Refresh or Recalc instead. Or you can issue Requery on those specific > controls instead of on the form. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.