Form confusion

[LesleyParker]

In a database I was examining, there was a table called customers in it, and in it there was a field called "Active". The field type was a yes/no, and the description looks like this : "Yes for current member to show. No for old member - Does not appear in list". (It is a check box)
Sure enough, I looked at the form called "Customers Form" and noticed that the ones that had their boxes checked in the Customers Table appeared in the list of customers, while those that have not been checked did not appear in the list.
Can someone please explain to me how this is done?
Thanks in advance. =]

 

[boblarson]

In the underlying query of the Customers form it will have the Criteria be Active=True so that only the records with Active true will appear in the list.

So, simply:

SELECT * FROM Customers Where Active = True

(that's the simplified SQL for understanding purposes)

 

[LesleyParker]

Oh, right, I see.
Thank you very much.

 

[boblarson]

Oh, right, I see.
Thank you very much.

No problem! Glad we could assist.

 

[boblarson]

And, by the way - Welcome to Access World Forums... I forget to say that frequently

 

[missinglinq]

FYI, this is a technique frequently used rather than actually deleting inactive customers. You can then have a twin form used to archive your inactive customers, sourced by a clone of your regular form's query by simply changing your criteria from Active=True to Active=False. Depending on your needs, you could then turn an inactive customer back into an active customer by unchecking the Active checkbox.

 

[gemma-the-husky]

and when you have related records such as sales history/invoices etc, its rarely appropriate to delete the sales account anyway, as you lose track of wwho the customer was, or worse still reuse the account number, with unwanted side effects!