Well I want the user to see all the result of a SQL request and let him be able to change the data. For exemple, change a checkbox cell unchecked to checked and save it (For a kindof list of presence, if the client was present, the user will check the checkbox).
I actually found a way to do this using subforms, but the result is really awful and I cant find a way to set a request SQL on my request table, because the request I use shows ALL the results instead of the resultts about the specific meeting... I tried to add a new temporary table with the ID of the meeting chosen, everything's shows fine but we cant change any data, so it is useless for me. So I need to select my request with a small SQL looking like
"SELECT * FROM reqMyRequest WHERE ID_Meeting = " & _
intMeeting
Because when I add ID_Meeting=11 as condition in my request table, everything's work fine... it is only when I go get the ID from another table that it says the recordset cannot be updated.
|