A few years a go I developed a database and this was working. Have tried npw and not open correct record.
The form has a command burron with the following:
/
The form has a command burron with the following:
/
Code:
Private Sub Command11492_Click()
On Error GoTo Err_Command11492_Click
If IsNull(Me![AssetID]) Then
MsgBox "Enter Asset Information before opening Employees form."
Else
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "employees"
stLinkCriteria = "[EmployeeID]=" & Me![EmployeeID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
Exit_Command11492_Click:
Exit Sub
Err_Command11492_Click:
MsgBox Err.Description
Resume Exit_Command11492_Click
End Sub
/[code]
It checks the EmployeeID in the assets table with the employee tabe and open the correct record in employee table . But now in open the first record in employee only. Can anyone explain why it now not working.
Never give up never give in.
There are no short cuts to anything worth doing :-)