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...
This code works perfectly, but I tried to simplify and somehow I got lost..
I tried to simplify the code without the use of so many [ ] but I am getting lost
The Commented Line:
'Me!PatientAdmitanceF!PatientNotesSF.Form!Pnote.SetFocus
was my futile effort, is there a better way...
Yes you are right, hence the reason I added that I was able to do it in a different way, you know the old saying..
"There's more than 1 way to skin a cat... :ROFLMAO: "
Pat I am more than grateful for your kindness and patience.
Regards.
Maurice.
Hey Pat.
I was able to do it in a different way, I found out that Mr. Richard Rost, has a form and code he sells on his website that is very ingenious, hence the reason I cannot post the code here since he makes money out of it.
In case someone is interested the only thing I can [And since you...
Like I said hats off to you sir.
I appreciate your patience, I'm 60 trying to evolve from FoxBase [Yep that OLD] and in order to keep my Job I have to adapt to this new world, I left programming for about 20 to 25 years for a new adventure in the same field but as a IT Admin, now the company...
Pat you are ABSOLUTLY right, I never thought about that [NEWBIE]...
Monday I will modify my form so that instead of trying to display a continuous form I have another code that displays on a text message,
this way it will show the duplicate record at my will of text / color and size.
Thank you...
Hello...
The data in the DB is just makeup names and dates not one is real, all of them are pure inventions of my imagination for test purposes only, no confidential data whatsoever.
HA... GOTCHA [for me...]
That was the reason of that particular subroutine and why I didn't use the proper name function of access, I had an issue and was breaking my head, someone send me that code and Problem Solved.
So I will go back to the subroutine.
Hey @Gasman , I am using a...
Done
The SQL instruction did work, no problem, it actually game exactly the record found, display it without any issue.
So that leaves the SubForm and I am guessing how is built or something..
I created the form using the Table as record source, then I just simply add the records I need to the...
Thanks for your suggestions,
The CleanUp was actually a leftover from the OLD program I had for this sub routine, is clean now.
I had the impression that the function vbProperCase didn't check names like "Paul Anthony" hence I found that alternative, but I tested a few times and seems like it...