cmd buttons issue

[LaRockera02]

Just did it no change

 

[LaRockera02]

do you think there's an issue because the the subform is a data sheet?

 

[vbaInet]

Let me see your db.

 

[LaRockera02]

I can't send it to you there's confidential info in it. YOu know what I'll make a copy of it without any data. Give a sec.

 

[vbaInet]

You will need to enter some bogus data.

 

[LaRockera02]

Sample database

 

[vbaInet]

Please ensure that you test the sample database before uploading it. You've included linked tables.

 

[vbaInet]

And change ALL the IsNull to Len before posting. I'm having to mention this three times.

 

[LaRockera02]

The New call Button doesn't work with the code you gave me, do you want me to remove your code? I dont' know if I can test it if it continues to give me an error

 

[vbaInet]

Test your database means make sure you send me local tables and not linked tables.

 

[LaRockera02]

Let me know if there's another issue I missed

 

[vbaInet]

I fixed a couple of things so see attached.

I don't know what NOTE1_subform control is so I commented it out. If that's supposed to be a control on your subform or the subform itself, then you can't validate it that way.

Also, if old records need to be validated too then in the On Current event of the form you will need to:

* validate using the Validation code
* if it failes, change the caption of the button to Save.

 

[LaRockera02]

It looks good. Note1_subform is the subform itself. So How can I validate it?

Also I'm noticing that if I type in a Note and hit New Call, the note from the previous record transfers over. Is there a way that it can come out blank everytime I hit new?

 

[vbaInet]

It looks good. Note1_subform is the subform itself. So How can I validate it?

What are you validating? The subform displays several records and a record is saved immediately you move away from the subform. Not as easy you think.

Also I'm noticing that if I type in a Note and hit New Call, the note from the previous record transfers over. Is there a way that it can come out blank everytime I hit new?

You've probably set the Default Value property of that field (at table level) and/or control (at form level). Or you've done it in code.

 

[LaRockera02]

So there's not easy way I can make the button check to see if the Notes section is also filled out?

Regarding the Note Default value properties, I checked what you said and they all blank.

 

[vbaInet]

Alright, I've done it. See attached.

I didn't notice any problems with the Notes field displaying a default value.

 

[LaRockera02]

This is Awesome!!!! I tweaked it and integrated into the database and it now works like a charm. Thanks, You rock.

 

[vbaInet]

You're welcome!