Adding a Count to any form... 2

[mdmarney]

How can I add a count of a total number of records to a form? I would like to know users inputting data to know how many total entries have been made.

 

[HNA]

Hi,

Try this on form Current:

Set rs = CurrentDb.OpenRecordset("Select * from TableName&quot
rs.MoveLast
Me.TextBoxName = rs.RecordCount


Good Luck
Do It Well, Or Don't.

 

[mdmarney]

That Worked Great. If I may...
How do I add a WHERE statement that selects only those records matching the field in the main form?
I tried "Select * from tbl_Attendants where Parish or Group ID = tbl_Groups_and_Diocese.Parish or Group ID"
I think the "tbl_Groups_and_Diocese.Parish or Group ID" part needs to match the selcted field in the main form, but maybe I'm not referencing it correctly. Help!

 

[chrissie1]

if both are numbers

"Select * from tbl_Attendants where Parish = " & me!parish & " or Group ID = " & me!Group ID

if parish is a string then

"Select * from tbl_Attendants where Parish = '" & me!parish & "' or Group ID = " & me!Group ID

if both are strings

"Select * from tbl_Attendants where Parish = '" & me!parish & "' or Group ID = '" & me!Group ID & "'"

and finally only group_id is string

"Select * from tbl_Attendants where Parish = " & me!parish & " or Group ID = '" & me!Group ID & "'"


"What a wonderfull world" - Louis armstrong