markdooler
Member
- Local time
- Today, 20:28
- Joined
- Nov 25, 2020
- Messages
- 58
Hi Everyone.
Need some help again.
So the setup.
I have a table (Day Sheet) of jobs and each job has an owner in the form of their initials. there is a field in this table called Serviceadvisor.
I have a query (Sadaysheetqry) set to display the data and it has a criteria of [Please enter initials] set in the Serviceadvisor field.
I then have a form (Sadaysheetfrm) that loads the data and when you open it it asks you to enter the initials. Once you enter them it only shows the jobs assigned to that person.
What i am trying to achieve:
The form is a split view and in the form there are some macro buttons that link to other forms (pretty simple).
When we enter the initials, if they do not exist, it loads no data in the dataset section and the macro buttons dont appear either.
What i would like to do is return an error message box that reads "There are no jobs assigned to a Service Advisor with those initials, please re-enter", then i would like it to reload the form and thus bring up the input box again.
Any ideas?
Ta
Need some help again.
So the setup.
I have a table (Day Sheet) of jobs and each job has an owner in the form of their initials. there is a field in this table called Serviceadvisor.
I have a query (Sadaysheetqry) set to display the data and it has a criteria of [Please enter initials] set in the Serviceadvisor field.
I then have a form (Sadaysheetfrm) that loads the data and when you open it it asks you to enter the initials. Once you enter them it only shows the jobs assigned to that person.
What i am trying to achieve:
The form is a split view and in the form there are some macro buttons that link to other forms (pretty simple).
When we enter the initials, if they do not exist, it loads no data in the dataset section and the macro buttons dont appear either.
What i would like to do is return an error message box that reads "There are no jobs assigned to a Service Advisor with those initials, please re-enter", then i would like it to reload the form and thus bring up the input box again.
Any ideas?
Ta