How to set the focus of a form and a combo box to a new record

[jlitondo]

I have a main form with an Add New command button which opens up popup form for a new record entry. After closing this popup, I requery the main form and its combo box.Does anyone know how to set the focus of this main form and its combo to the newly entered record? jlitondo@gatecitysteel.com

 

[DougP]

Set focus
Dim SyncCriteria As String
Dim f As Form, rs As Recordset

Forms![Firstformname].requery

'Define the from object and recordset object for the AutoCAD form
Set f = Forms(Screen.ActiveForm.FormName)
Set rs = f.RecordsetClone

' define the criteria used for the sync
SyncCriteria = "[YourField]='" & Me![YourField] & "'"

' find the corresponding record in the Parts table
rs.FindFirst SyncCriteria
f.Bookmark = rs.Bookmark

Forms![Firstformname].form!Combobox.setfocus

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[jlitondo]

Thanks a bunch DougP! This is very interesting. The only thing is that "Forms![Firstformname].form!Combobox.setfocus" only sets focus on the combo box and clears out its text to show a blank combo box.So what I did is to assign my pk to a variable, requery my combo box and then reinitialise it to this variable so that the new record entered is also displayed in this combo box, i.e. Thanks again.

Forms!MyFormName!MyComboName.Requery
Forms!MyFormName!MyComboName = MyVariable
jlitondo@gatecitysteel.com