Requery - set focus

[Wayne-I-M]

Hi all

Got a mind block and this "has" to be presented in the morning. Just
putting finnishing touches to new DB and .....

Private Sub PaySource_AfterUpdate()
Me.PaySource2.RowSource = "SELECT ID, Item FROM" & " tblPay2SourceSpecific
WHERE PayTypeID = " & Me.PaySource & " "
Me.PaySource2 = Me.PaySource2.ItemData(0)
Me.Requery
End Sub


Code work fine - but - need to requery the form to set combo items but this
causes the focus to be taken back to tab stop 1. Need it to set focus to
another control (PaySource2). ????

Many thanks

(13 hours till presentation - it "will" be ready LoL)

 

[Wayne-I-M]

Forget the last post. Mind block. Cup of coffee fixed it.

Thanks for looking away

 

['69 Camaro]

Hi, Wayne.

Need it to set focus to
another control (PaySource2).

Use the combo box's SetFocus procedure immediately after the form is
requeried:

Me.Requery
Me!PaySource2.SetFocus

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Wayne-I-M]

Ha Ha

Does this mean great minds think alike.

I really shouldn't be doing at this time on a sunday night.

Many thanks anyway



--
Wayne
Manchester, England.

Hi, Wayne.

Need it to set focus to
another control (PaySource2).

Use the combo box's SetFocus procedure immediately after the form is
requeried:

Me.Requery
Me!PaySource2.SetFocus

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, Wayne.

I knew you knew the answer! But sometimes late at night even the
things we know like the backs of our hands try to elude us. That's usually
a reminder that it's time to get some rest.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.