Recent content by cheekybuddha

Do you mean between 10 and 50 records?

The clue was in the click event signature in Post #1 ! At least @disgracept uses useful object names! (y)

See: Post #14 Post #17

It is the image. I placed an image and a button on a continuous form, each with a click event to MsgBox the record ID. Clicking image only picks up the ID of the first record, whichever record is clicked. Clicking Button shows correct ID as expected.

Try placing a transparent button over the image and use its click event to run the open form code.

Are you sure? The second argument (View:=acNormal) is present, and Where comes two after that.

Yes, perhaps image control can't receive focus, so it isn't changing the current record

Try it with just: Private Sub img_VerImovel_Click() DoCmd.OpenForm "frm_VerImovel", acNormal, , "Imovel_ID = " & [txt_ImovelID] End Sub

What does this mean?

How many records does QryJsonPos001 typically return?

What happens if DaysLeft = 0 ? I guess you could also use: SELECT t.Status, COUNT(*) AS [Count] FROM ( SELECT IIf(Days left >= 0, 'Valid', 'Invalid') AS Status FROM AllDeliveredQ ) t GROUP BY t.Status ;

One thing to double-check: With table [Date calc] in design view, what datatypes are DueDate and DatePaid ? Or if [Date calc] is a query, what is the SQL of the query?

Follow my instructions in Post #17. If you don't know how to do it, then let us know.

Switch you query to SQL view. Copy and paste the SQL here. We can show you the corrected SQL. Then you can paste it over the SQL of your query. Then switch back to query view and you will see how it is constructed by Access in the query designer.

With [Expr1], you are comparing with a string instead of a number. Try: Expr1: IIf([Days]>4,"Yes","0")