Getting a Filtered Record Count...

[kalebson]

I have a Form that has a button that opens another form which displays various promotions and blah blah.. I use this to open the form:

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "ViewJobTitle"

stLinkCriteria = "[EmpID]=" & Me![EmployeeID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command28_Click:
Exit Sub

Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub

This opens a form and shows me the different job titles a person has held based on their EmpID.. What I want to do is have a MsgBox pop up telli\ng me .."This employee has held (the number of records on form) job positions.)

I have tried using RecordCount however im probably not using it correctly.. Can anyone help me? TIA

 

[MelissaKT]

What about the DCount function? You could use Dcount("The Name of your Field", "What table the information comes from", "[EmpID] = '" & me.EmployeeID & "'")

 

[Eupher]

Me.RecordCount does not work? Can you be more specific about what you have tried that doesn't work?

Ken S.

 

[ZmrAbdulla]

[tt]Me.Recordset.RecordCount[/tt] ?

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[kalebson]

Thx guys DCount works fine..and Me.Recordset.RecordCount both work now that I added the "Recordset" part to it. I was just doing Me.Recordcount and I guess for some reason since its a linked Form it didnt like it or something.. Thanks again for the help.

 

[Eupher]

Sorry, I goofed in my post. Zameer had it right. Glad you got it sorted out, kalebson.

Ken S.