Dlookup problems

[Steve_b]

I have a form that uses dlookup to populate names that come from another table. Often times the dlookup does not refresh. Hitting the f9 refresh will only refresh what is visible on the screen. Only a reboot solves this. I have seen numerous posts on this and it does not appear to be fixed. Is there an alternative method to use? My code: This is an a text box. When it works it works nicely. Thanks for any insight.

DLookUp("glnotes","gradelevels","grade_subjectid = " & [Forms]![schools1]![teacherResources1]![grade_subjectid])

 

[Ranman256]

Instead of textbox & DLOOKUP,
try combo box. It uses a query and auto updates.

 

[sneuberg]

I hate that bug which from my understanding is just in Access 2013. We use the Count() function to display the total record count in our forms. It would just come and go and sometimes even rebooting didn't help. Like you F9 would always show it.

I just checked this on our system and at the moment it's working. That may be just because it's in a good mood or it may have been fixed in a recent Office update. You might check to see if you have the latest updates.

If that don't help you might be able to fix your problem by updating the text box in the current event.

 

[Steve_b]

I am populating my form with a name from another table in a format similar to a datasheet view. I am not visualizing how a combo would help.

 

[Steve_b]

SOLVED Re: Dlookup problems

I came across this function replacement for dlookup which has solved my problems. It uses a recordset to populate data. Thanks to developer Allen Browne.

http://allenbrowne.com/ser-42.html

 

[sneuberg]

Re: SOLVED Re: Dlookup problems

I came across this function replacement for dlookup which has solved my problems. It uses a recordset to populate data. Thanks to developer Allen Browne.

http://allenbrowne.com/ser-42.html

I'd keep an eye on that. I don't see how a change of function would fix that problem.

 

[Steve_b]

All I can tell you is that I had consistent problems with dlookup not refreshing. Only reboots would solve the issue. I believe I even applied a patch from Microsoft to fix this (Ms Access 2010). I can add that this has happened on Windows 7, 8 and 10 on different computers. I have not had the problem since replacing dlookup with elookup.