still needing help on update query button

[cdell7up]

Ok, maybe if you can explain to me how I can define a table, because keep
getting a compile error, variable not defined. And it highlights my "AnswTbl"
statement. I understand some code but it has been sometime since I have written


any. If i can get a lesson on syntax for both my append querry and update query
it might help me realize what I am actually trying accomplish. I will attach
what I have so you can see what i might need to do.ChecklistDBv1.041_1.zip

[pbaldy]

You have to do the same thing you did in

Private Sub cmdAddRecords_Click()

IOW, create a variable with the SQL and then execute it. You also need valid SQL:

WHERE QuesNum >= 1001 AND QuesNum <= 1401

[cdell7up]

Another person on this forum wrote the code for the Private Sub cmdAddRecords_Click() and I understand some of what he did but not all. Would it be easier for me to create an update query in design view of access and then have the button call that query? I try to use the append query as a guide but I just don't have enough understanding to write the code for myself. I would appreciate any help I can get on this.

[pbaldy]

It would be fine to create a query and save it, then execute it from code.

It's fine to get code from the forum, but then you need to understand it. If someone gives you code you don't understand, ask questions and research it until you do.