Using a query as a filter for a form

[andy_dyer]

Hi,

I am using the following code but it opens the form blank instead of with the 10 records that are displayed in the query.

The query links to the same table as the form is linked to and only has one criteria for when one field is Null.

DoCmd.OpenForm "frmPicture", acNormal, "qryMissingImage", acFormEdit, acWindowNormal

Any ideas why it is not working?

 

[andy_dyer]

Hi everyone!

I'm still stuck on this, any suggestions would be gratefully received!!

 

[KeithWilliams]

Hi Andy,

Looks like you have missed a comma before acFormEdit. According to the syntax of OpenForm, that would use the enumerated value acFormEdit as a Where condition for the form's result set.

Hope that helps,
Keith.

 

[andy_dyer]

Yes, that now works great!!

How simple was that?? And how silly do I feel?

Thanks v.v.v. much for saving my sanity!!