Problem with loading a report when a control is empty

[Zaeed]

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?

 

[georgedwilkinson]

Do you mind showing us your SQL?

 

[Zaeed]

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

 

[gemma-the-husky]

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

 

[Zaeed]

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

cheers gemma