How to refresh after moving to the next record

  • Thread starter Thread starter JP SIngh
  • Start date Start date
J

JP SIngh

Hi All

I have a form which displays values in 3 textboxes based on the value
selected in the dropdown. It all works well when I change the value in the
dropdown combobox the textfields change to reflect the new values.

However when I am browsing the records using movenext, moveprevious buttons
the textboxs keep the values of the first record.

If i was browsing the records using my own command buttons i could write the
following code in the button click event to make it work

Me!txtEventDate = Me!Combo55.Column(2)
Me!txtArtist = Me!Combo55.Column(1)
Me!txtEventName = Me!Combo55.Column(3)

But I don't know where to put this code when using the access 2000 built in
record navigation buttons

Can someone please help

thanks
 
Put the code in the form's Current event procedure.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top