I have a simple form, "Positions" for hiring, it's a simple list of open positions.
I want to have a field that displays "number of candidates being considered", but this isn't working out.
I was able to create a query that shows the count, but when putting this as the recordsource for the form, then I can't create new records.
So the data should look like this
Position Department Num of Candidates
Mktg Director Mktg 3
Sales Director Sales 2
What's the approach for this ?
I have a query with the number but not sure how to implement.