SynTax for null query?

[WinDancer]

I want to update a form field to 'No' if a query result is null.

Help with the syntax, please?

Thanks,
Dave

 

[Brianwarnock]

Just do it in the query.

Brian

 

[WinDancer]

Can anyone help?
Thanks,
Dave

 

[Brianwarnock]

I was serious, if you have a form bound to a query and a field in that query is Null then the easiest place to change that to No is in the query.

NameforForm:IIf([IsNull(originalfield]),"No",[originalfield])

Brian

 

[WinDancer]

I was asked to include a subform field in an error checking routine for an application that I built a couple years ago. That form is populated by a query from a table.

The field they want checked for errors in populated by a different query. There are 5 possible outcomes for that subform. If that total is less than 5 it means that the data entry folks left a specific field in the database blank. That must be corrected.

I created a new query against these records that counts the checked boxes and stores that count in the different table.

The system is built and in use. I have a ton of other work to do. I just want to move that stored count to a specific field on the form. I can't get this done.

The code as is and NOT working fires when the form is opened.

I tried various combinations of the setvalue function and could not make that work, either.

Me.Text92 = Tables!tblSurveyResultsCount![CountofChange?]

 

[Brianwarnock]

Ah! not the question I answered, and I don't know the answer to this. To get an answer now you may have to start a new thread with the explanation in your last post.

Brian

 

[Rich]

What is [CountOfChange]?

 

[WinDancer]

[countofchange?] is a single numeric field in an unrelated table that I am trying to copy to the open form.

I am going to give this a try on the VB forum here.

 

[Rich]

[countofchange?] is a single numeric field in an unrelated table that I am trying to copy to the open form.

I am going to give this a try on the VB forum here.

Use DLookUp

 

[WinDancer]

=DLookUp("[Countofchange?]","[tblSurveyResultsCount]")

did the trick.

Thanks!

 

[Brianwarnock]

Can I just say that the final question bore no relation to the original, infact neither did the explanation in Post 5

Brian