If you changed 'program' to ProgramName in the code should not be prompting. Status should be updated only for the records that have that ProgramName because of WHERE clause, if there is more than one then yes all those will change.
Query not functioninng Properly
VIP
Windows XP 
Access 2010 32bit
If you changed 'program' to ProgramName in the code should not be prompting. Status should be updated only for the records that have that ProgramName because of WHERE clause, if there is more than one then yes all those will change.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Expert
Windows 7 Access 2000
I caught it, I input the code wrong. Thanks for all of your help!!!!!
Time not Sorting Properly in Report
Report does not update properly
Cannot split a DB properly
Delete SQL statement not working properly
Posting Permissions
Reply With Quote