If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to SetFocus to right field in form
Hi All.. And PLEASE don't say it...I know it's posted elsewhere...
Some people MIGHT look at one newsgroup and not others and will have the answer...Sorry Here is my orig Question, and it was responded to by Jeff but what was given did nothing but get me a Macro Error message. Mabey someone els knows.. I have searched the MS Knowledge Base but found nothing that helps there. I have a form called MainFrom. When I open this form it has a subForm that I use to lookup Customers. My problem is when I open this Main form it's focus is to the center or the Detail section of the form. I need to First fill some data in the Header section. How do I set focus that when I open The Main form it First lets me enter the data in the header part of the form? I can click the mouse in the first field and that works but I shouldn't have to do that....I don't think. I have looked at the Tab settings and it does not let me do anything but change tab order of the fields, Not Sections. Any Ideas? Thanks |
#2
|
|||
|
|||
Trying to SetFocus to right field in form
Put the following code in the Open event of your form:
Me!NameOfFieldInHeader.SetFocus -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "JustMe" wrote in message . .. Hi All.. And PLEASE don't say it...I know it's posted elsewhere... Some people MIGHT look at one newsgroup and not others and will have the answer...Sorry Here is my orig Question, and it was responded to by Jeff but what was given did nothing but get me a Macro Error message. Mabey someone els knows.. I have searched the MS Knowledge Base but found nothing that helps there. I have a form called MainFrom. When I open this form it has a subForm that I use to lookup Customers. My problem is when I open this Main form it's focus is to the center or the Detail section of the form. I need to First fill some data in the Header section. How do I set focus that when I open The Main form it First lets me enter the data in the header part of the form? I can click the mouse in the first field and that works but I shouldn't have to do that....I don't think. I have looked at the Tab settings and it does not let me do anything but change tab order of the fields, Not Sections. Any Ideas? Thanks |
#3
|
|||
|
|||
Trying to SetFocus to right field in form
I wish to Thank You Very much...
It worked... "PC Datasheet" wrote in message ink.net... Put the following code in the Open event of your form: Me!NameOfFieldInHeader.SetFocus -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "JustMe" wrote in message . .. Hi All.. And PLEASE don't say it...I know it's posted elsewhere... Some people MIGHT look at one newsgroup and not others and will have the answer...Sorry Here is my orig Question, and it was responded to by Jeff but what was given did nothing but get me a Macro Error message. Mabey someone els knows.. I have searched the MS Knowledge Base but found nothing that helps there. I have a form called MainFrom. When I open this form it has a subForm that I use to lookup Customers. My problem is when I open this Main form it's focus is to the center or the Detail section of the form. I need to First fill some data in the Header section. How do I set focus that when I open The Main form it First lets me enter the data in the header part of the form? I can click the mouse in the first field and that works but I shouldn't have to do that....I don't think. I have looked at the Tab settings and it does not let me do anything but change tab order of the fields, Not Sections. Any Ideas? Thanks |
Thread Tools | |
Display Modes | |
|
|