![]() |
|
#1
|
||||
|
||||
![]() Without seeing the form and the fields involved, this is not easy to resolve. It appears that you are using legacy form fields, but how is it determined which of the three people involved are completing the form? If you are only checking one field then no-one would be able to save it without filling that field. Surely the first two must be able to save without that field being completed? What type of fields are the relevant fields e.g. Text, Dropdown, CheckBox? What is the relationship between the named field "TriagedBy" and the field "PrimaryGroup" and various users who complete the form? You are going to have to explain this a little better or attach a copy of the form.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#2
|
|||
|
|||
![]()
As you may guess from the form I work in a specialist doctor clinic. The form begins be filled out by clerical staff, and then referrals are triaged for priority and which clinic to book into by other staff. I have attached an image of the form.
I wasn't clear in the original post (my apologies) but yes, I don't want the prompt to appear for the early users - only the final user who initials the "TriagedBy" box (which is just a text field) must complete the "Primary Clinic Group" box, which is a drop-down box with a set of options. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Alternative for Multiple If Conditions? | zguan1 | Excel | 2 | 05-25-2017 09:12 AM |
![]() |
BlindMouse | Excel | 1 | 01-27-2016 12:19 AM |
Vba that shows an error message for certain conditions | Ellebb | Word VBA | 7 | 09-21-2015 11:24 PM |
![]() |
z941714 | Excel | 8 | 08-09-2015 04:12 PM |
![]() |
bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |