Search results

Could you please post an example of this code? I have a database with personal address on one side and business on the other. For report & query purposes I want to make the "COUNTY" field a required field but only on either the personal or business side. EG, if a business address is filled in...

Quick question for you. I know how to set a required field, but how do I edit two field so that they are dependant on each other? IE. How do I set my form to make FIELD1 required ONLY if FIELD2 is empty and vice versa? Thanks very much and I hope I've explained myself correctly.

Thanks Ken, although I didn't realise this first post was actually submitted (webpage told me I needed to login again!). Remember that I'm a newbie to Access so you need to explain in basic, basic terms! I will look up "subordinate 'union' query" and see what I find. Thanks.

Hi everyone, Managed to build an Access database with switchboard, forms, reports & queries but I'm left with two annoying problems: 1) I have two columns in my main table called "SOURCE" and "SOURCE 2". They both take their data from a table called "SOURCE". I run a weekly query so that the...