Requery - set focus

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

'69 Camaro

G

Guest

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

'69 Camaro

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Focus on Requery Propblem 2
Setting the Focus after a requery 7
requery text boxes 2
Setting focus on a specific record 5
Problem with Form Refreshing after losing focus 2
Lost Focus - Requery 8
Requery Form & Stay At Same Record 7
Unable to set focus to another field in order to hide Calendar Control 1

Top