Open Form and Link To Specific Record

[burrina]

I want to go to record 3 HelpKey 3 or HelpTie 3 they are the same. HelpKey is a counter, HelpTie is a number.


Descrition in tblRef field is OrderDetails Customer



Ok, I am close now but cant get to the specific record I want.It opens the form but goes to wrong record.
On Error GoTo Err_Command55_Click
Dim strFormName As String
Dim strCriteria As String

strFormName = "tblHelp"
strCriteria = "[tblRef].Value =(3)" 'I need to go to HelpKey or (HelpTie which is a number)which is a counter with the value of 3,i.e. record 3
DoCmd.OpenForm strFormName, acNormal, , strCriteria

Exit_Command55_Click:
Exit Sub

Err_Command55_Click:
MsgBox Err.Description
Resume Exit_Command55_Click









The name of the form I am trying to link back to is frmHelp

Main form is named OrderDetails


Can I do this?

[orange]

Please describe exactly.
Combobox has a rowsource and it wouldn't be CustomerID - at least not as I understand things.
Your rowsource would be a table/query or value list.

see if this helps
http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

[burrina]

PROBLEM SOLVED:


On Error GoTo Err_Command55_Click
Dim strFormName As String
Dim strCriteria As String

DoCmd.OpenForm "tblHelp" 'Opens Help Form and Goes To Corresponding Record.
DoCmd.GoToRecord , , acGoTo, 2
Exit_Command55_Click:
Exit Sub

Err_Command55_Click:
MsgBox Err.Description
Resume Exit_Command55_Click