new to access and having problems

[jgipe307]

im wanting to show a print preview of the record in the database from certain field. in the report i want name and next epr. when I show the report it shows the name but not the date. can some one help

 

[JamesMcS]

Hi, welcome to the forum!

We'll need to know a few more bits and bobs - firstly what is the report based on? Have a look in the underlying table/query to see if the data you want displayed is actually there. If it is there, we'll need to see the table/query structure, and what fields you've got in the report at the moment.

 

[jgipe307]

I attached the file if you could help i would appreciate it

 

[JamesMcS]

OK, I see the problem. Next EPR is empty for every record in the table, hence nothing to show.

Populate that field in the table and you'll see what you typed in on the report.

 

[jgipe307]

There is a expression on the form. It suppose to return a date 11 months after the date in the current epr. That is if I done it right. And thank you for looking at it so quickly

 

[JamesMcS]

I don't think you have, sadly. The Next EPR field in the form is a calculated control that doesn't relate to the table (it's not bound to that field). Either:

(a) put the expression in the report
(b) put something in the afterupdate event of the current EPR text box to say [next epr].value=(then your expression here)