The main table will keep records of what we call authorizations..
The reason why it has to be the way is designed:
Each authorization has many parts 1 of them is
What Specialty do we send the patient to: [Ophtalmology, Gynecology, Cardiology, etc]
once we know that then we decide which doctor...
Pat they are working as a parent Child if you go back to my initial post, you'll see how the picture #2 shows the link on the Specialists sub form, It works UP to the point where a NEW Specialty has to be entered then if for any reason the EU moves the mouse to the specialists I do not check...
That's exactly what is happening right now.... [Answering @ebs17 as well]
This is a MAINTENANCE routine for the EU (End User)
So here the EU has to input the new Specialty and then what Doctors do attend that specialty [One to Many]
One Specialty ---->> Many Doctors
not the other way around...
I am trying to kill 2 birds with 1 stone..
The End User [EU] has the responsibility to enter BOTH
here is the caveat:
If there is a specialty there has to be specialists, so this is a Maintenance routine.
hence the reason, once they have all that info, the Program will eventually require that...
Thanks I tried 2 different solutions there:
1) on the "On Enter Procedure" event of the second sub-form I tried just to check:
Private Sub SpecialistF_Enter()
If Me.Specialty.Form.Dirty Then
MsgBox "Form Specialty is Dirty"
Else
MsgBox "Form Specialty is NOT Dirty"...
Hello All:
I have this simple form, is working fine or so I thought.
The form is a combination of 2 SubForms Sepicialty and Specialist
my problem is that when there is a NEW specialty the End User can click on the specialist subform and simply add Dr Names without even adding a specialty...
Pat, I have no Idea what intellisense is, I honestly have no idea, so when you guys refer to 'ME" i am clueless, I do understand that me refers to the form, and replaces the need to write the name of the form, that is as far as I understand.
I tried Pat and just got worst.
then I tried this:
- Verify all data is there and the User Ok
- Set the focus on the subform
[ I did previously set the tab order on the subform so that the field I need is the ONLY one available and with TAB }
- when I run the code the focus goes to the subform...
Thanks
I just followed an example I found here in the forums, unfortunately I lost the reference but I will try to look it up again, said that I need to reference the subform then the subform plus the object and since it worked I let it go, thou I found more refcerences online as well, none...
Thanks Uncle Gizmo..
Love it..
I set it up, and it worked like a charm, I just got rid of the brackets, very elegant and I learned something new.
I will try to study a bit more about the use of WITH, seems very nice.
Thanks
the reason why I did it like that it is because I found an example and the author said it was needed to first set the focus on the subform, then set the focus on the object.
It is here in this forums, I just lost the reference, but if I find it again I will post it.
Also I have NEVER...