Full Version: ComboBox bound to Query needs to save to different table
UtterAccess Discussion Forums > Microsoft® Access > Access Q and A
srichey
I have a combo box with a query from the employee table that shows the 'EmployeeID','FirstName', & 'LastName'. i need to save the text of the box to a field in the 'Week1' table. Can't seem to think of the right code to do this.

I wanted to start with:
Dim RS2 as recordset
set RS2 = new recordset
recordset.open ("Week1", dbOpenTable)


This gives error of "Expected ="

Please Help??
Larry Larsen
You have cross posted this thread in multiple forums. Please post questions only to one forum. Double posting and cross posting does not improve your chances of finding a solution.

"Double Posting" and "Cross Posting" are not allowed here at UA as they only create confusion with the people that may try to help you.
Please post your problem in only one forum and only once within that forum.

UA Moderator
srichey
Ok sorry! No Problem
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.