List of record number

[eugz]

Hi All.
I would like to create a form that remind user which record is not complete. Some times user don't have ability to fill up form completely and need wait couple days of addition information. In that case will helpfull reminder form to display number of record. How to create form with ListBox to show number of not completed records?
Thanks

 

[pbaldy]

What signifies whether a record is complete or not? Simply add a WHERE clause to a query that looks for that.

 

[Moniker]

There are several ways to do that. The most straightforward way is to make a field on the table that is boolean (Yes/No) called "Completed". The way to update that is simple, something like this:

If (Field1 is not null) And (Field2 is not null) And (Fieldx is not null) Then Completed=True

For a query, just write an UPDATE query that makes sure each field is not null (put "Is Not Null" in each field's criteria) and have the UPDATE be Completed=True.

Finally, for your listbox, just fill it WHERE Completed=False.

~Moniker