I have a report that is filled via a query. This works, however one of my fields does not always contain a value, and when this happens, Access jumps up and asks what you wish to put in there.

Does anyone know how to stop this?

Do you mind showing us your SQL?

Sorry for the delay Geroge, i've working on a bigger issue..

Here is the SQL..


SELECT tbl_Change.ChangeNumber, tbl_Change.Initiator, tbl_Change.Title, tbl_Change.Description, tbl_Change.Primary_Location, tbl_Change.Secondary_Location, tbl_Change.Status, tbl_Change.Date_Start, tbl_Change.Change_Nature, tbl_Change.Change_Type, tbl_Change.SafetyText, tbl_Change.QualityText, tbl_Change.Safety_Impact, tbl_Change.Quality_Impact, tbl_Change.FoodSafety_Impact, tbl_Change.HR_Impact, tbl_Change.Environment_Impact, tbl_Rejection.RejectionText
FROM tbl_Change LEFT JOIN tbl_Rejection ON tbl_Change.ChangeNumber = tbl_Rejection.ChangeNumber
WHERE (((tbl_Change.ChangeNumber)=GetChangeNumber()));
tbl_Change stores all the information from the form. If the form is 'Rejected' then an entry is made on tbl_Rejection, with some accompanying text explaining the rejection. I then include this description in the report via the LEFT JOIN.

The issue is that in a lot of cases there is no Finish Date set. This thus causes the Report to give an error when loading.

Thanks for any help you can give

you have a field in the query that doesnt exist - so access asks you what value you want to use for that field

check your fields in the sql again

haha your right.. i thought i had that field in there so i dismissed that as a possibility...

cheers gemma