DLookUp only updates when i close the form

[infantrie]

I have a couple of DLookUps on a form and they only seem to update when i close the form! i suppose i could just enter the data and close the form for every entry, but i was hoping there was some fix i could put on the thing.

thanks

 

[Trevor G]

From the field you are using behind in the properites look for either after update and then use a requery or refresh to the dlookup field

 

[infantrie]

Thanks very much. I've also now noticed that the data, whilst updating on the form is not actually making it into the table. I'm giving up. The gods must have been crazy to come up with this access thing. i'm going back to excel where humans are a natural part of the landscape. Thanks again for responding!

 

[raj08536]

My understanding is that dlookup only bring data to form but not to update table.....

You need to use ADO or DAO.

 

[strive4peace]

ADVERTISEMENT

" i'm going back to excel where humans are a natural part of the landscape"

oh don't give up on Access yet! You are right that many things are easier to do in Excel -- but here is where knowing when to use Excel and when to use Access is important.

If you change data and that causes the dLookups to get different values, you may just need to save the record to get them to refresh. On the AfterUpdate event of each of the source controls:

   Me.dirty =false

"dirty" is a form property that gets set to TRUE if a record has changes that need to be saved

if me.dirty then
is the same thing as
if me.dirty=True then

me.dirty = false

~~~~~~~~~~
if this doesn't do the trick, post the ControlSource for the controls that aren't getting the values updated

 

[infantrie]

thank you very much! funny thing though, when i changed the AfterUpdate event, my text was automatically changed from Me.Dirty=False to You.ShouldProbablyGiveUp,Jackass=True.

jk of course, but i wouldn't be surprised to see that at some point. i am going to try to implement that now. i really appreciate your time.

 

[strive4peace]

LOL! If you have more questions or this doesn't do the trick, let us know