Recent content by Jomat

Thank you. I will use that along with the timer. I for some reason cannot recreate the error. It might be after a few compact and repair, it just didn't happen again. Clicking on the button 30 times or so continuelessly didn't produce the error again.

Edited. I already created a timer on the form to auto reload and took the reload button away. But is still curious why the error occurred. Hi all. I hope someone can shed some light on an issue that i have. I have a main form that have a query sub form to show some recent checked in data...

ThAnk you

Thanks guys. I found the errors.. i was stuck on this for two days. For example. I have: Nz(Forms!MYVIEWS!COOKIES!AMOUNT, "") but it should be: Nz(Me.MYVIEWS!COOKIES.Form!AMOUNT, "") Also added: Dim amount As Variant And finally: On Error Resume Next On Error GoTo 0 Thank you for all the...

Thank you. I will try that.

Can you give me an example?

Sorry I forgot to mention, the amount is a form caculate field from a query.

Hi all. I'm getting an error when I run the following codes. I have two text field that changes colors on a form based on a subform. I think the problem is when the subform field is blank. I'm getting the error when I navigate on a single form to the next form that have a blank amount in...

Thank you for your inputs. I appreciate it.

I reread your post. You are correct. My original thought was to use the conditional formatting expression is without creating any new queries or forms. I've done this years ago but don't remember how. Thanks for your inputs.

Pat i did what you suggested. Join add the status field. Condition on the status field. Works. Thanks much.

I will try that

MY apologies that I'm not clear on my explanation. I've uploaded a screen shot. I'm trying to get FORM1's sumoft_amount to show green based on FORM2. In FORM1 the records 1 and 3 should be GREEN. I'm trying this expression in the conditional formatting but can't get it to work: I'm using the...

I didn't see that post. There are no relationship between the tables. In Form1, the sumamount field is a total of many fields, pull from a query. In form2, someone manually makes inputs in a different table saying, "hey I looked at this record, on this day, in the amount of say $15.00 and I...

I will post a screen shot when I get back to the work station. The intent that i am trying to accomplish is to make it easier to see that an invoice has been processed Or posted. For example, when an invoice have been posted to the journal on the form2 then on form1 the amount field will turn...