I am really struggling to get to grips with this issue, would grateful
for any advice.
I have a form 'Applicant_Person' with various student contact data.
There is a combo box to 2 options of either 'Enquiry' or 'Application'.
If 'Enquiry' is chosen then cmd button 'Interviews' needs to be
disabled.
If 'Application' is chosen then cmb button 'Interviews needs to be
enabled.
I have managed to get this to work via a macro on the 'On Exit' of the
combo box. However this only works if the inputter is creating a new
record or changes the combo on an existing record.
What I need to happen is that when the 'Applicant_Person' form is first
opended populated with a students data, the cmd button is
enabled/disabled dependant on what is in the combo box at that time.
If I put the code into the 'on open' of the form, this would only work
when the form first opened.
I am really stuck and as you can probably tell I have limited
experience.
Many thanks
Carl