current checkbox problem

[jason]

i am putting together a database for mobile phone issues. it is to track who
has what number currently and model of phone, when they were issued this and
when they return it so i can create reports based on current list, check
when the number changed hands in case of phone bill issues, etc

i have seperate tables for users, cost centres, tel numbers, models
i have 1 table that brings this together called issues and in this i have a
date issued and a date returned column, also a yes/no checkbox column for
current

i use a form for new issues and the default value for the yes/no current
checkbox is yes as a new issue will be current

what i want to happen is when i enter a date in date returned column id like
the yes/no checkbox to change to value No - this will allow me to query all
the current issues by using the yes/no value and report on those

but how do i do this?

 

[jason]

hmmm ... re-reading this - would it be better to not have a current yes/no
column and instead, anything that does not have a value in date returned is
therefore current ... ?

 

[jason]

ok, now im lost ...... how do i create a report that shows all records in
table 'Issues' that do not contain a value in the date returned column? This
report would be my current list of users/numbers.

 

[fredg]

ok, now im lost ...... how do i create a report that shows all records in
table 'Issues' that do not contain a value in the date returned column? This
report would be my current list of users/numbers.

Make a query using the table as it's record source.
As Criteria for the [Date Returned] field, write:
Is Null

Base the report on the query.