Updating Table to New Dropdown List Selection

[Lrn2Code]

Hi,

I'm relatively new to programming and am trying to figure out how to update a value in a table when the value in the form changes. The form has a drop down list and I don't know how to get the newly chosen value from that list to be saved. My code related to saving information from that form is pasted below -

strSQL = "Update tblSchoolClasses set coursename = '" & strName & "' where courseid = " & lngID & " and  coursecat = '" & strcoursecat & "' and POSID = '" & strPSID & "' "
Debug.Print (strSQL)
Set qdf = CurrentDb.CreateQueryDef("", strSQL)
qdf.Execute

The strcoursecat is the category field where the drop down list selection should be updated in the table. Is this something that needs to be coded in the form as an "on change" event procedure? If so, how does that work?

Thank you for any guidance you can provide.

 

[SkipVought]

Hi,

You might want to ask Access related questions in an Access forum like forum702, forum705

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Lrn2Code]

Thanks! I tried to do a search yesterday but must not be using the right terms. I'll do more research. Thanks again.