OK, I got creative with part of it. I only have one person that needs to fill in the doc number and corresponding information. Then she will distribute it to the engineer who needs it. They will fill out their portion and submit back to her. What I did... I created a form (in Access 2007) with all t...

I think I might have found a site that explains how to do what I need to do. I am going to play with it today and see if I can make any headway. http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/My biggest problem so far is that I need it to open with the fields blank until...

Good Morning Paul,Yes and Yes. I have an Access database that I have all the part numbers, names, rev #s, process owner, etc. This is a document control (DC) project. I need my DC coordinator to be able to Email Engineering Change Forms to the engineers, have them fill them out and return them. My g...

Good Afternoon Paul,I was wondering if you would be so kind as to send me the sample file also. I was also wondering if, in this sample file, it offers the solution to populate other fields depending on the value in a drop down... Example...I have a part name Widget1. The part number for Widget1 is ...

Thank you, it didn't work though. I found a work around that I have incorporated already however. I created read only text boxes and put them behind my radio buttons. I then call out the text boxes to fill in when the conditions are right. It makes the button appear as if it has a "colored frame" ar...

I am trying to write the script to display a message and change the color when a field when it is not filled in or a radio button group when the user did not make a choice. I am able to get the text fields working properly, however, I cannot make the radio button group work. It displays the message,...

Paul,Thank you!!! It works just like I want it to now!Jenn D.

Hello,I have a similar situation. I have been able to make a certain field mandatory when a particular box is checked. My problem is that I do not know how to make it optional if the user changes their mind and unchecks the box. Is there a way to make this happen? Thank you in advance for any help.J...