Opt-in data entry

[azhar2006]

Hello Guys
I have a question!
Field in a table where four fixed values ​​(A / B / C / D)
Can I make my product, for example, (a) when the number of records to 75 record for this category


Shows me a warning or message or not to include the possibility of class (A) in the fields
In other words, each class has the upper limit is 75 and so on

[orange]

You can run a query or a DCount with criteria and check the quantity at any time.

[azhar2006]

Thank you very much
orange
Is it possible to explain the expression or function

For example, the domain name (AS) in the table
Class name is (A / B / C / D)
Thanks for helping me

[orange]

Let's get the problem defined so readers understand it.

Your post dealt with:
field
table
product category and
class

My interpretation was if a field in my table is A ( similarly B|C|D)
can I determine or ensure I don't ever have more than 75 of these records.

But you response is no clearer to me. In fact now you have added domain.

Give an example if you can not describe your requirement clearly.

[ItsMe]

In fact now you have added domain.

Just an FYI. Domain appears in intelisense when using Dcount() and other Domain Functions. It is asking for a table or query object.

[azhar2006]

Thank you
I'll explain it
For example we have a school where the number of classes for students
Each row accommodates 75 students
I want to be when the number of students in the classroom (a) 75 is to stop accepting student extra
The sense to stop the introduction of a new record

[ItsMe]

Dcount will count the number of records. You can choose a field name to apply criteria. Maybe you have a Yes/No field that will indicate whether or not you want to include it in the count.

The following would count the number of records where the yes no field = True. It is counting the Primary Key field where YesNo = -1 in the given table name (Domain).

dim intCount as integer
intCount = DCount("[PrimaryKeyField]", "TableName", "[MyYesNoField] = -1")