Hello to all, I have just registered here. I am relatively new to Access and am having a real problem with command buttons and how to code them!!!!!
I have a Form [Site_Details] that covers one aspect of data gathering (information on individual sites) and on this form I have 3 Command Buttons [MC_Details] [Pharm_Details] and [PCT_Details] each of which opens their individual forms respectively (Address and contacts info for EACH site) - no problem to open a new form and no problem to open a form that has been filled out. But what I want is to be able to press one of these buttons and open the matching address for the site and if there isnt one for a new form to open. Everything i try seems to either open all new or all exisiting with no new form. this is prob really easy once you know how BUT ITS DRIVING ME MAD!!! Please help.