Recent content by Yorksdummy

Hi Privateer The situation you mention doesn't happen in my case - we're not big in the UK on naming sons after fathers etc but that aside my situation is an over-50s club so it's highly unlikely 2 people with same full name at same address - so will go ahead with your initial suggestion and thanks

Hi Privateer The table has a composite primary key of Surname/First Name/Postcode which are the 3 fields being input on the form. If the record exists I need to display the details on a form. If not I need an input form with the rest of the input to create the record. Hope this helps

Hi Plog It's turning it into code that's the problem!! Can't work out how to find if the record exists or not. i understand the DCount stuff but I don't know how to access the table with the 3 fields in VBA

Haven't used Access and VBA since 2001 so having problems doing the simplest things. I know what I want to do but can't!! I have a table with a 3-part primary key. Have a form with 3 unbound controls corresponding to the 3-part table key. After the 3 form fields have been entered I want to...