Open a Form to a Particular Designated Field

[djclinton15]

I Cansuccessfully open a Form to a designated particular field if it's a New Record.



PrivateSub Form_Load()
DoCmd.GoToRecord , , acNewRec
Me.DayTime.SetFocus
EndSub

However,what if I wanted to open a Form to a designated field say in the First Record?

Itried replacing 'acNewRec' with 'acFirstRec' but it didn't work.

PrivateSub Form_Load()
DoCmd.GoToRecord , , acFirstRec
Me.DayTime.SetFocus
EndSub

*Am Ito assume that one can only open a Form to a designated particular field ifit's a New Record?

Anyadvice/suggestions will be greatly appreciated! Thanks in advanced.

[vicsaccess]

would it be easier to just use the set order by method?
https://msdn.microsoft.com/en-us/lib...ffice.15).aspx

private sub form_load()
docmd.setorderby"id ASC"
end sub

[Missinglinq]

Your argument should be

acFirst

not

acFirstRec

But why move to the first Record on opening the Form...the Form will open on the first Record...automatically!

PrivateSub Form_Load()
  DayTime.SetFocus
EndSub

Linq ;0)>

[NTC]

hmmmm - if you seek to open the form and have the focus on a specific field/control - - one can accomplish that using the tab order of the form; no code is needed at all.....

[Missinglinq]

hmmmm - if you seek to open the form and have the focus on a specific field/control - - one can accomplish that using the tab order of the form; no code is needed at all.....

I took the OP's explanation to mean that he wanted an existing Record to open to one Field/Control and a New Record to a different Field/Control, but I could be wrong! I've done this a time or two, when all data needed to be entered for a New Record, of course, but only one or two Fields, typically, needed to be updated, on existing Records.

Linq ;0)>

[djclinton15]

First, thanks to all for responding to my thread! No Ling, you were partially right the first time in thinking that I wanted 'an existing Record to open to one Field/Control.' One would assume (even I) a simple solution would be changing the tab order & placing the desire field/control at the top. However, in doing just that, the Form still opens up in the first first field/control vs. the designated field/control I'vs set in the tab order. Needless to say, I'm quite pondered & frustrated in something to rectify this issue.

Hoping without need to go into depth, I have a Table of music artists/for which I daily listen to & are pre-dated. I also track the duration (length of time I play/listen to the artists/group on the current date. I created a Form (datasheet viewed) displaying the day, the current/today's date, the ArtistsID, & the duration (empty). Therefore, each day AL I need to input/update in this Form is the Duration field/control played per ArtistsID. It wouldn't be far-fetch to want to have this Form open up in the Duration field/control beings that's the only field empty. Beings the Duration field/control only requiring daily updating, which might be be understandable why I would want the Form to open up in the field/control

Please excuse my lengthy explanation; I'm just trying to provide a better picture/understanding on my objective.