help with access database

5 pts.
Tags:
Access Database
ComboBox
Microsoft Access 2007
Parameters
Refresh Report parameters
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,

Software/Hardware used:
access 2007, windows xp

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following