Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists various property details associated with each address and each record is unique with an autonumber primary key column. I am trying to create a form where i can select the file (unique value from table 1)number via combo box (which i have created a query for to list all file numbers). Once the desired file number is selected from the combo box i would like another query i built to run using the selected file number (from combo box) as the parameter for the query and displaying the desired property details (stored in my second table) elswhere on the form or in a subform on the form... whatever. I would also like to be able to then enter or change info on this portion of the form/subform and have it update the appropriate record in the table (table 2). I actually had it mostly working yesterday, but then i tried to add a little further functionality... (getting it to display the address stored in table 1 refreshing every time a new value was selected in the combo box) and blew the whole thing up... problem is getting it to work yesterday was a total fluke, which i seem unable to repeat. I've found many discussion of others trying to do the same thing (combo box to query with a requery every time a new selection is made in the combo box...), but most of the discussions end up leading into VB, or SQL or get beyond me in expression building... I need instructions that your dog could understand... this is the first time i've used access in almost 10 years and even at that point i only had a portion of an introductory computer class dedicated to access under my belt. I'm using 2007, but have 2003 available. I'm intelligent enough to follow good instructions, just very unfamiliar with the terms and lingo. I would really, really, really appreciated 5 min of someone's time on this! Thanks,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!