Search results

Hey, I don't think I'm understading what you want me to do. How do I validate the subfrom from the button click event? What you have replied sounds like what I'm looking for but I'm not sure on how to do it. Please elaborate thanks

ok sorry. the command botton I have is pretty basic. it's just set up to append a record on the main form. What I'm looking for is for this button to check the fields in the subform and make sure data is entered in them. If not, I don't want the user to go on to a new record. I want it to be...

He Cbrighton thanks for replying. I'm sort of a novice when it comes to this. I'm not entirely sure where I should put that code. Should I put it on the Button itself, or the form? and on which one? BeforeUpdate?OnClick? thanks

I have a main form (CallDatabase) and a subform(NOTES). I have a button that appends a new record everytime you click on it. I would like to make it require for data to be inserted into the Notes subform, specifically the Note field. I want to make sure the user won't be able to move on to a...