Search results

Hello, I have a customer form with a Yes/No checkmark box. I would like if the box is checked, for a button to be visible that allows the user to go to a form. Please forgive my ignorance as I'm sure there's probably a very easy way to do this. Thanks in advance for the help and insight. Scott

Thanks Talismanic for the help! I've tried entering that code before update on the phone field but it's not working. I'm attempting to use this on phone because it should be unique. Here's how I entered it in: Private Sub Phone_BeforeUpdate(Cancel As Integer) Dim Answer As Variant If...

I'm sorry- I hate to be a bother but I'm still fairly new to this. I'm having a little trouble with the argument. Do I type that string in exactly as seen or where do I enter my names? My form name is Customer Information Form-Main. My field name is Last Name and the information is stored in...

Hello, I have a customer form with personal information (ie name, address, phone, ect.). I am trying to create a control that dosen't allow duplicate customer information to be entered. For example if an address is entered already in the customer table- then if someone enters the same address...

Hi Jack, Thanks for the help. What is the advantage of doing it this way verses changing the form properties upon edit to run a macro that updates the date field to current date. I haven't tried this yet but is it still better to do it the way you mentioned. I was eventually going to do...

Hello, I have a customer information form that has a last updated field. Currently our data entry person has to manually update this field any time the form is changed but I would like to find a way to automate this so that upon editing any fields in the form (or subform), the field (last...