Recent content by Skaven

I'm not really concerned if someone enters both a Part number and a Quote number - it might happen once in a while. What I'm really concerned with is the Part No Quote No scenario. Do you have sample code I could look at to prevent the No/No event?

Hi there, I have a table called ENGTIME. (Access 2003) Fields in question are PartNum & QuoteNum On my form, I need to make sure one of these 2 fields is populated for every record. On records with a Part Number listed, there will never be a Quote Number and Vice Versa. I have set all of...

Hi, I'm using Access 2003. Table: Parts Fields Parts Customer Quotes All of the Parts are unique, however the same customer name may appear on several different Parts records. Goal: I need a form with a combo box to select the Customer name from a list (based it on a query that...