Go to a record that is in a combobox

[cgclower]

OK, I know I am close on this one, just can’t seem to find exactly the right code to make it work.



I have a form with a combo box that displays the names of customers from the tblCustomers table. Beside that I have a button that opens a split form of the tblCustomers table so the user can edit the table if they wish.

When clicking the button to open the split form, I would like the record that was last selected in the combo box to be the one highlighted in the split form. I am trying to use GoToRecord, but can’t seem to make it work.

 
Private Sub Form_Load()
 
    DoCmd.GoToRecord  ,  ,  acGoTo,  [what goes here?]
 
End Sub

I need to somehow get the value of the combo box and put it at the end of the GoToRecord command…but how?

Thanks for the help!

[June7]

Easier alternative to GoToRecord is to filter the opening form to specific record using the WHERE CONDITION argument of OpenForm in the button Click event:

DoCmd.OpenForm "form name here", , , "CustomerID=" & Me.comboboxname

[cgclower]

Thanks for the tip! I thought about that too, but doing that only gets me the records that match the WHERE condition. I would like ALL the records in the table to be displayed, but the "current" one (the one displayed in the combobox) to be pre-selected in the split form.

[June7]

Here is one method I have used:
http://www.access-programmers.co.uk/...ad.php?t=36579

One I haven't tried:
http://bytes.com/topic/access/answer...omd-gotorecord

[HiTechCoach]

Oops wrong thread.

[cgclower]

Thanks everyone for the help! Here is the code I ended up using:

 
DoCmd.FindRecord DLookup("Name", "tblCustomers", "CustomerID = " & Forms!frmContracts!CustID.Value & ""), , True, , True

Thanks again for the tips, you guys rock!