Not Able to View Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database that allows the user to input information using a
form. In the form, one of the fields is a required "date submitted" field.
The next field is the "date due back" field which I have created an
expression to automatically insert the date that is 10 days ahead of the date
submitted.

When I try to view the date due back field in the "table" view, it is blank.
But I am able to view it on the form itself.

I would also like to create a report that only view "open items". I have
crerated a "check box". Is there a way that I can create this report. I am
not a code writer and am a beginner in expression building.

I have compacted & repaired my database, but no luck.

PLEASE...any Assistance would be appreciated.
 
Use the AfterUpdate event of the [Date Submitted] field to set the value of
the [Date Due Back] field.

If you are not comfortable with code, it would be possible to do it with a
macro. Use the SetValue action.

For the report, create a query. In the Criteria row under the yes/no field,
enter:
True
The report based on this query will then contain only the records where the
yes/no field is Yes.
 
The due back date is probably a calculation in the textbox's Control Source.
This make it a calculated control, not a bound control. A bound control
would have a field as its Control Source and would save its value in that
field. It is NOT normally recommended to store data that you can easily
calculate, so you have done this correctly. Just calculate the date when you
need it. You don't need the field in the table.

To create the report, you have two options. 1) You can add a filter to the
report to show records where the checkbox field is checked (True) or
unchecked (False). 2) You can create a query based on the table and set the
criteria for this field to True or False (one or the other, as desired).
Base the report on this query instead of on the table.
 
Back
Top