Footer works but not Header in Access Forms

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

Guest

Hi

I have developed some simpel tools for a course I am on at University.

I use the footer to cumulate totals from the records. It works fine.

I have put two simple fields in the header which require two different
'years' put in.

While the application is open and in use the entries for the years remains
visible across all records.

If I save, close and re-open the databse the details in all fields including
the footer rermain but the details in both fields in the header are lost and
require re-entered.

Can someone please offer an explanation ?

And a solution or work around would be even better appreciated.

Thanks

Jay
 
Jay said:
Hi

I have developed some simpel tools for a course I am on at University.

I use the footer to cumulate totals from the records. It works fine.

I have put two simple fields in the header which require two different
'years' put in.

While the application is open and in use the entries for the years
remains visible across all records.

If I save, close and re-open the databse the details in all fields
including the footer rermain but the details in both fields in the
header are lost and require re-entered.

Can someone please offer an explanation ?

And a solution or work around would be even better appreciated.
Click to expand...

Data entered into unbound controls on forms is lost when the form is closed.
The stuff in your footer is the result of calculations based on *stored*
data. If you want the data entered into the top controls to be remembered
between form sessions then it has to be saved somewhere (in a table) so it
can be retrieved the next time the form is opened. Forms cannot store data
by themselves.
 
Rick

Hi

Thanks I shall try that and see if it resolves.

If there is anything further I shall email you directly or Post again

Cheers

Jay
 
Back
Top