Update Query problem (1 Viewer)

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?
 

Blackwidow

Registered User.
Local time
Today, 16:15
Joined
Apr 30, 2003
Messages
149
Its Okay Now

Sorry... all fixed... I had an extra table in my query that wasnt needed and it prevented the update query from working properly....


In future will wait till I have fully woken up in the morning before posting messages!
 

Users who are viewing this thread

Top Bottom