Display number of records in a table on my form... to update every time a new record is added

[chimp8471]

I have a form which i want to display the number of records in a specific table.. and update every time a new record is added automatically



I put a Textbox on the form and got it to display the qty

used this as the lookup

DCount("*","tTempPartsIssued")

but i get #Name? as an error in the box...

Any help would be appreciated

[ranman256]

you can put a control refresh in the TIMER event.
set the timer interval = 10000 (10 seconds)

Private Sub Form_Timer()
txtBox1.Requery
End Sub

[Micron]

I'm confused

I put a Textbox on the form and got it to display the qty

but i get #Name? as an error in the box...

So it works but it doesn't? What you have should work but why not just use the built in navigation control, which shows the record count of a table? Or is the form is filtered?

[Bulzie]

Pick a field in the table and not * to count?

[chimp8471]

Sorted thanks all.... I will get there eventually

[Micron]

The usual last step is to post your solution for the benefit of others who might have the same issue in the future.