Any problems using the "on current "event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access.
Are there any problmes if I use the "on current" event.

I have a combo box which queries based on the value of a field on the form.
I am using the "on current" event to do a requery of this combo box.

Thanks,
Shailaja
 
shailaja,
If that's the proper event to trigger the requery of your combo... sure
it's OK.
hth
Al Camp
 
Are there any problmes if I use the "on current" event.

Depends on what you are trying to do. On Current can be a great place to
check the status of a record and hide/unhide various controls...but if you
start to put a lot of action in this event you can 1) slow up moving from
record to record and or 2) cause the on current code to fire multiple times.

This second issue can lead to unexpected problems. Careful debugging can
sometimes be helpful in the case where you fire off an event more often than
you want, but often I get a little F5 happy and miss the real "action" that's
causing my bug...
I have a combo box which queries based on the value of a field on the form.
I am using the "on current" event to do a requery of this combo box.
Click to expand...

This is a good place to requery a combo box if the contents of the list can
change from record to record. Be sure that if you need to requery without
moving to a new record that you do so in an appropriate event...
 
Back
Top