Recent content by fsjavan

Here is what I did to figure out the update queries. In Access once I got the query to do what I wanted I changed the view to SQL view. At that point I could see the SQL statement. Then I wrote the SQL statement to a string variable and did debug.print so I could see the statement in the...

Maybe i have... But to use your example. tblLowerDie is not the same as tblBilly. It would be more like tblEightGrade. The way im seeing it is, tblLowerDie.dienumber field is what is holds billy, suzie etc. Each of these 11 subcomponent tables have a unique part number (student name in your...

Sorry Mark I must not be explaining well. I think you broke that down a bit too far, I can populate the comboboxs without any issues. I can even submit the data.. I just didn't want to run the select case in the twice. I thought it would be poor coding to duplicate it. When it could be ran...

Your right. the select case is hard coded. but that would be due to my lack of knowledge on how to determine the select case as a variable. Part of the code that I did not include was on form load I am doing an open recordset to populate the combo box values for vehicle make. So yes it would...

New user, first post, and love the site its been very helpful so far. I haven't found the answer yet so I am posting :) I have a form with 2 combos and a txt box that is ultimately performs an update query when submitted. The form is what sets which table needs to be updated based on the combo...