Inactive or active

[Bruzer]

how do I make a record active or inactive? so it does not get reported from a query?

[pbaldy]

Generally, a status field of some sort. It could be a Boolean Yes/No field, a text field containing "A", "T", etc. Then you simply apply the appropriate criteria in your query:

WHERE FieldName = True

WHERE FieldName = "A"

[Bruzer]

I have a yes no text combo box but do not know how to apply the criteria, what should the criteria statment should read?

[pbaldy]

I already gave two examples of what it might look like. Adjust them to match your actual data.

[TheShabz]

I think theres a misunderstanding here. This isn't something that is located on your form. It is a column that should be in your table. We call it ActiveInd. If a record has a 1 for ActiveInd, it is active. If it has a 0, it is inactive. Then to find active accounts only, you "WHERE tblName.ActiveInd = 1". This should be something taken into consideration when the table is being initially created. I dont see how you would go back and add this feature later on.