HELP!!! Can't see the data

H

Hawaiian Chick

I have created a form. In the form I created i have autmated a date field to
display the date 10 days in advance. It works fine in the form because you
can see the date displayed.
But, when I try to view the date in the "table" there is not data shown (the
date isn't displayed).

I need to see the date. HELP PLEASE!
 
R

Rick B

Is the field on your form tied (bound) to the table? What are you doing?
Defaulting in the current date plus 10? Or adding 10 to another date field
already stored in the record?
 
H

Hawaiian Chick

I am trying to forcast a "due by" date by adding 10 days to the date of
submittal.
How do I figure out if the field is bound to the table?

Help.

Rick B said:
Is the field on your form tied (bound) to the table? What are you doing?
Defaulting in the current date plus 10? Or adding 10 to another date field
already stored in the record?
Click to expand...
 
R

Rick B

Look at the properties of the control and see if it is tied to a field.
Check to make sure the "control source" contains the name of a field in your
table.

Note, that if this will ALWAYS be ten days after the submission date, then
you don't need to store both dates. You could simply add ten to the
submission date anytime you wnat that due date. If the Date+10 is just a
default that will be changed by the user, then it DOES make sense to store
both.


--
Rick B



Hawaiian Chick said:
I am trying to forcast a "due by" date by adding 10 days to the date of
submittal.
How do I figure out if the field is bound to the table?

Help.
Click to expand...
 
H

Hawaiian Chick

Thanks. I needed that! I have another question:

How do I create a report that only selects items that have not been closed.
My closed/complete field is a check box. What should I do first? (create a
query or do the report first?

Thanks again,
 
R

Rick B

Personally, I would create a report and then poen the report properties box
na in the record source, click the builder (...) and create my criteria
there. I don't like saving a report and a query.

The easiest way is to first build a query. Include criteria to only include
items where your closed field is false. Save that query.

Create a new report and select that query as your record source.
 
Top