K
kernelsan
Guest
hello, sorry if i ramble a bit i want to be thorough I have an update query which i have assigned to a button on form. the form shows the records in tblJOBS. the form has a field which shows the jobID of the current record
and a show next record button etc
the update query is:
UPDATE tblJOBS SET tblJOBS.JobID = forms!frmJOBS!JobID
it is supposed to update the record with the value shown in the currently opened record in the form. However it actually updates every record in the table with the value in the currently open jobID control.
Is there any way i can change this query to update only the current record shown in the form?
thanks alot for any help
and a show next record button etc
the update query is:
UPDATE tblJOBS SET tblJOBS.JobID = forms!frmJOBS!JobID
it is supposed to update the record with the value shown in the currently opened record in the form. However it actually updates every record in the table with the value in the currently open jobID control.
Is there any way i can change this query to update only the current record shown in the form?
thanks alot for any help