I am quite new to Access, know what I need to do, quite happy to try but have
got stuck.
I have a sub form that details any work passed to a contractor and whether
it is completed or not.  On my main form I have a completion date.  I want to
test if there is any work outstanding with contractors before a completion
date is allowed.
I have written a query that gives me the number of outstanding contractor
jobs and tried to link that into my form but with no luck.
My main form is based on a query and I have tried to re-write the query to
include the number of contractor jobs, whilst this shows the correct number I
am then unable to update any of the data on the main form, once I remove the
link all is ok.
Any help would be appreciated.
Thanks in anticiptation.