Requery - set focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.



'69 Camaro said:
Hi, Wayne.
Need it to set focus to
another control (PaySource2).
Click to expand...

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.
Click to expand...
 
Back
Top