Search results

Still getting the same error message: "Enter Parameter Value: Forms!NAV_DATABASE.NavigationControl0.NavigationSubform.Form.SetStudy"

I'm not 100% sure I understand the distinction between "navigationsubformName" and "navigationsub form" I tried the following, but it doesn't resolve the issue. [STUDY NAME]=Forms!NAV_DATABASE.NavigationControl0.FRM_PROTOCOL.Form.SetStudy)

Hi all, I have a combo box with the following row source: SELECT distinct TBL_PROTOCOL.[PROTOCOL NUMBER] FROM TBL_PROTOCOL WHERE (([STUDY NAME]=Forms.FRM_PROTOCOL.SetStudy)) ORDER BY TBL_PROTOCOL.[PROTOCOL NUMBER]; It works completely fine in the form itself, but when the form is accessed via...

I'm trying to run an update query with multiple join statements in VBA, but I keep getting "missing operator" errors. Same happens when I try to run the SQL in query builder. The SQL is: UPDATE TBL_DocReview_SingleStudy INNER JOIN TBL_LOA ON TBL_LOA.MemberName = TBL_DocReview_SingleStudy.Member...

Forgive my ignorance, here. The automatic setting for the bound column is "1". What should it read?

Thanks Paul. I set Combo33 to requery on Combo42's after update. This does seem to refresh Combo33, but to an empty set of values. Would the problem then be in how I'm querying from the tables?

Hi everyone, I'm trying to limit the values in a combo box (Combo33) based on the previously-selected value of a different combo box (Combo42) in the same form (FRM_TRAINING_PROTOCOL). In the row source for Combo33, I have: SELECT TBL_PROTOCOL.[PROTOCOL NUMBER] FROM TBL_PROTOCOL WHERE...

I'm working with a preexisting database here, so forgive me if this seems a bit clumsy. I'm trying to populate an entry in the table TBL_CURRENTUSER with the value of the record in the table TBLUSER that corresponds to the username/pass entered into the login form that this code applies to...