Blackwidow
Registered User.
- Local time
- Today, 16:15
- Joined
- Apr 30, 2003
- Messages
- 149
I want to update a table depending on an update query...
Basically I have a screen to log Student Certificates... I want them to be able to click a check box yes/no and then run an update query... I have set the update query to update only records with Yes in the check box and in the update to on the query I have put the following...
Under the field Certificate - [Which Certificate?] and under the department field I have put [Which Department?]
Basically I wanted the update query to run asking those to questions and then it to fill the fields in with this information in the table...
However to no avail.... is this at all possible?
the girl inputting the certificates at the moment has to fill in this information for each student - she will only be running one type of certificate at a time.... so that is why I thought a update query would work.... but it isnt
Any ideas?
Basically I have a screen to log Student Certificates... I want them to be able to click a check box yes/no and then run an update query... I have set the update query to update only records with Yes in the check box and in the update to on the query I have put the following...
Under the field Certificate - [Which Certificate?] and under the department field I have put [Which Department?]
Basically I wanted the update query to run asking those to questions and then it to fill the fields in with this information in the table...
However to no avail.... is this at all possible?
the girl inputting the certificates at the moment has to fill in this information for each student - she will only be running one type of certificate at a time.... so that is why I thought a update query would work.... but it isnt
Any ideas?