Recent content by CodeCurious

That fixes it! Thanks very much!

I have a requery when the form loads (after the query executes, which is OnOpen), but also tried your suggestion, BigHappyDaddy, and added it to the procedure. Still not working ...:( Thanks for the suggestion.

I added an ORDER BY clause, but that didn't seem to help. It seems like there's a 'disconnect' between the query and the form, in that the form shows data that isn't returned by the query and does not exist in the result set. However, I believe that the data that shows in the form is from a...

Here's the SQL for qryEvaluateApplicant (after it has been created by the procedure): SELECT tblFilmApplicant.app_student_id, tblApEvaluator.evaluator_ID, [tblFilmApplicant.app_first_name] & ' ' & [tblFilmApplicant.app_last_name] AS Name, tblFilmApplicant.term_value...

Hello- I’m having a problem with form fields not updating correctly. The form (frmEvaluation) is bound to a query (qryEvaluateApplicant). qryEvaluateApplicant is created in a VBA procedure. This procedure runs on the OnOpen event of frmEvaluation. On the OnLoad event of frmEvaluation, I...

Thanks very much. I thought I had tried that at one point and was still getting the error. But when I try it now, works fine.

I'm writing a function that mimics login behavior for an Access database. Here's an overview: - User enters a login ID in a textbox (txtLogin) in a form - VBA Public Function uses DLookup to lookup the user's role in a table in the database, based on the value in txtLogin, and stores it in a...