I'm hoping someone who knows their VBA will be able to help me with this. I have a table called t_sampleTable, which has 2 columns ("recordID" and "testAdd").
I have a variable called variableAdd, which holds an integer value.
I also have a variable called recordVar, which holds the recordID.
I want to add the value of variableAdd to the table, on record recordVar.
I know this must be simple but I can't get it to work for me!
I have opened the recordset for editing, and I can add data to it no problem - I just don't know how to add the data to a specific column for a specific record.
This is for work, not homework (my homerwork would be Java )
I hope you call help -- p.s - If possible, I'd like to not use a SQL string to do this