I have a form on which I have two listboxes. list1 and list2 how can and I want to update a field of the table whose fields match with list1 and two boxes.
At the bottom of the same form i have a textbox I type in the the new value and click on the button, it edits all the selected records by putting the value from the text box and and updates them.
Can someone help me with the syntax of the SQL statement
I don't know how the syntax works..
set recodset = currentdb(select,...)
At the bottom of the same form i have a textbox I type in the the new value and click on the button, it edits all the selected records by putting the value from the text box and and updates them.
Can someone help me with the syntax of the SQL statement
I don't know how the syntax works..
set recodset = currentdb(select,...)
