Refreshing a form using the primary key.

[doneill]

Hello, Ihave spend way too much time trying to refresh a Form that is driven from asingle table. The Form has a few simple Text and Combo dropdown boxes using simple queries to other tables and obviously joining to the maintable. I am trying to add a dropdown /combo to refresh the Form when I select new data. My Combo box is giving me the primary key, TransID, that is also an AutoNumber. With that ID I would like to refresh the form. I have tried various flavors of the belowwith little success. I am new to ACCESS/ VB so keep that in mine.


Debug.PrintMe.Combo183.Value
** 112932


'Triedvarious combinations of the following....



strSQL= "SELECT * from services where TransID = " & Me.Combo183.Value
Debug.Print strSQL
** SELECT * from services where TransID =112932

' DoCmd.RunSQL strSQL --won't compile
' DoCmd.GoToRecord acDataQuery,"strSQL", acNext, 1 -- won't compile

DoCmd.FindRecord Combo183.Value, , False, ,True, , True ' goes to next Record
DoCmd.GoToRecord

Me.Combo183.Requery

DoCmd.RefreshRecord

Me.Combo183.SetFocus

[pbaldy]

If you're trying to load the form with just that record, your SQL could be used as the form's record source

Me.RecordSource = strSQL

[Gicu]

Try this in the AfterUpdate event of the combo:

Private Sub Combo183_AfterUpdate()
On Error Resume Next
Me.TransID.SetFocus 'assumes you have a visible text box bound to TransID
DoCmd.FindRecord Me.Combo183
Me!Combo183.SetFocus
Me.Combo183= Null
End Sub

Cheers,
Vlad