Proaccesspro
Last Activity: Mar 20 '08, 04:55 PM
Joined: Apr 25 '07
Location:
-
The "Has Multiple Appeal" button on the MAIN form contains the code in question... -
Scott,
I sent the DB to you.......Leave a comment:
-
Scott,
Tried to send the email, but it is not enabled.......Leave a comment:
-
Scratch that...it's 2002...Leave a comment:
-
I'm using version 2000....is that a problem??...Leave a comment:
-
I can send you a sanitized version......Leave a comment:
-
Scott,
It still blows on lime 2...Keeps telling me it cant find the field Actions Subform
It does set the focus to the Case subform on tab 2....Code:Forms![MainForm]![Case subform].SetFocus Forms![MainForm]![Case subform].Form![Actions Subform].SetFocus Forms![MainForm]![Case subform].Form![Actions Subform].Form![Action Date].SetFocus
Leave a comment:
-
"However, it didn't result in a blinking cursor in the text box ready to receive user input! I'm assuming this is what you are after?" ---- > Y E S!!!
Also, when I run the code, the compiler blows up at said line and gives me this error: "can't find the field Actions Subform"...Leave a comment:
-
Scott,
Well were getting closer but I STILL can't get it to work....Here is what I have:
Forms![MainForm]![Case subform].Form![Actions Subform].Form![Action Date].SetFocus
Does it make any difference that the Actions Subforms' default view is datasheet?...Leave a comment:
-
Stewart,
I have subforms within each of the different tab controls. Hope this makes sence....Leave a comment:
-
I uploaded the form...This shows the second tab on the main form...As you can see, there are 2 additional forms on this tab...I need to set focus to a text box on the 3rd form (one on the bottom that is just visable)...Leave a comment:
-
Will do............. ..........Leave a comment:
-
I think a light bulb just went on!! I just realized the text box I am trying to set focus to is actually located on a third form...I have the main form, then the actions subform, and then a case subform.....SO, I have 2 subforms contained on 1 form....How would I reference the nested forms???...Leave a comment:
-
OK, I zipped the file.....The subform is on the APPEAL INFORMATION tab...
I will upload a snapshot of that also...Leave a comment:
-
5 MB............. ............Leave a comment:
-
it will not allow me to upload the bmp...says the file is to large!!!...Leave a comment:
-
The form name is indeed Actions Subform...Leave a comment:
-
Stewart,
Thanks for the help on this....Forgot to mention in my post that in fact I tried to add the .setfocus command and it still does not work. When added, I get this error: can't fing the field actions subform
Here is the code I have:
Forms![MainForm]![Actions Subform].Form![Action Date].SetFocus...Leave a comment:
-
How???????????? ??????????????? ???...Leave a comment:
-
Stewart,
Here is what I now have:
Forms![MainForm]![Actions Subform].Form! [Action Date]
The only way Access likes the code is if I have a space between Form! and [Action Date]. When I run it is still gives me this error "can't find the field '|' referred to in your experssion.
If I try to remove the space between Form! and [Action Date] is get the compile error: expected =...Leave a comment:
No activity results to display
Leave a comment: