Dlookup field not updating every time
Posted on 2004-11-30
I have a really weird problem, and I'm running into a HUGE time crunch. I have an Access 97 database with several tables, queries and forms. It's not a real complicated database. I have a form that has a Dlookup field. This field should automatically update when I change another field. However, it's not changing all the time. It depends on certain records that I choose from my drop-down in the one field that determines if it will automatically update my dlookup field. I can't find any rhyme or reason to it. I have a Requery on the AfterUpdate and OnChange events for the one field. However, it's not updating my Dlookup field. It will, however, update the field as soon as I exit the form and come back in or if I change from Design View to Form View. That's why I keep thinking I need a requery somewhere in the Form Properties, but I can't figure it out. HELP - and FAST!!!! If this doesn't make sense, I'd be glad to send my database to someone who can help me. I'd give 500 points, but I don't have that many to give.