Search results

I do not have an on change.

How would i do that? As an attachment?

Yes, the subform is linked through Master Child by Check #

It is not bound to anything. I think it jumps around because i am typing in an existing check # and it's bringing up that record.

I have a form that contains a subform. They are linked by the Check #, so that the check number updates or creates the records in the subform. As i type in a new check number, the subform records jump around to the old check number as I type. How can stop this if it is a new record/check?

That was it. Thank you. I have it working. I thought I tried that but must not have.

I'm trying to do a sum if. If Client Title is "Chairman", sum the $Medicare. I have it as =Sum(IIf([Client Title],"Chairman",[$Medicare])) and I'm getting, This expression is typed incorrectly or it is too complex to be evaluated.

what does that mean. I could not find my other post.

Currently I am getting an error with this code =DMax("tblDemoTrans","RecordNum")+1

=DMax("tblDemoTrans","RecordNum")+1 . It is a number field.

I am trying to create a Dmax in a subform to increase my "RecordNum" field. It either doesn't work or it produces the same number all the time.

Hi, I'm from Wisconsin in the US. I'm retired and like to garden and crafty stuff. I used to work in Access for 20 years but since retiring 1.5 years ago, I've gotten rusty. I have recently been asked to update an Access database and probably take updating over.