Ok this is driving me mad. I can never get this right.
I have two tables, both with a field called SON. One table contians
the main data and customers and job status. The other table is for
logging faults and failures of that job.
On my main form i have created a button called "Log Fault" that
creates a fault log. This stores the data into the [Fault Logging]
table. I also have a button called "Close Fault" which opens a form
which is getting it's data from a query that runs that shows only the
records that match the main forms SON number.
Query Criteria
Loaded forms
[forms]![form - touch find]![son]
This works great!
Now this is where i am stuck. I have made the "Close Fault" button
disabled and would like it to become enabled when i am on the record
on the main form [form - touch find] if the [SON] number exist's in
the [Fault Logging] table.
Does anyone have any ideas.
I have done this before but it was looking at a field in the same
table. I only have problems when i need to look at another table to
get my result.
