form question

[kathi2005]

Okay I am getting close to finishing these forms.

Have my subform pulling from a query. There are cases where the query will return a null value; however on the form if the query returned a null value I am getting an error message. How can I correct this one

[boblarson]

Change the control source of the control that is bound to that field to something like this (replacing with your actual field name):

=IIf(IsNull([FieldNameHere]), "", [FieldNameHere])

Also make sure that the control that this field is bound to doesn't have the same name as the field (which is the default when Access creates a control for you). So if your field was named Price you would use txtPrice for the control name and use the Field name of Price in the control source.

Also, if the above control source gives an error you might need to use

=IIf(IsNull([FieldNameHere]), 0, [FieldNameHere])

if your field is numeric.

[kathi2005]

This is one is confusing me. I have to fields that are almost Identical - they each look at the query then pull the picture file from the table
The first

=IIf(IsNull([Cap Picture]),0,[Cap Picture])

is working
BUT

=IIf(IsNull([Logo Picture]),0,[Logo Picture])

is not

[boblarson]

Is there a control named Logo Picture (just like the field name) on the form? If so, you would need to rename the control from [Logo Picture] to maybe txtLogoPicture.

[kathi2005]

Nope that did not work. I am getting the error

"The Microsoft Access database engine cannot find a record in the table 'Logo Picture' with key matching field(s)"

I am not getting the error if this field is not null

[boblarson]

Is Logo Picture in the form's Record Source? Also, what datatype is the first one and this one? Are they both the same datatypes?

[kathi2005]

Yes Logo picture is in the form's data source. Both datatype's are attachments

[boblarson]

Well, I don't use attachments so I may not be able to help any further with this one. For displaying pics I would store them in an accessible file server location and then use the Picture Box to display them based on storing the PATH and file name.