Number of records?

R

Rolf Rosenquist

I need to prevent the user to register more than a specified number of
records for a certain kind. Is it possible, with help of code in a form, to
test how many records there is in a table?

/ Rolf
 
C

Cinzia

Rolf Rosenquist said:
I need to prevent the user to register more than a specified number of
records for a certain kind. Is it possible, with help of code in a form, to
test how many records there is in a table?

/ Rolf
Click to expand...

Hi Rolf,
you can use DCount("FieldName", "TableName", "Condition") to know how many
records there are in a table, in BeforeUpdate event.
Bye
 
Top