Looking up, limiting and storing data from another table

[ssanfu]

Great!
Ready to mark this solved?

[CT_AccessHelp]

I ran into one more issue with this.

If a user selects a county from the CNTY dropdown the correct Accounting_Code is displayed in the Accounting_Codes dropdown for the particular county however, if they change the county selected under CNTY the Accounting_Code does not update to the new Accounting_Code. It will only update if they close the form, come back in and the change it. Is there any way to fix this?
It was updating but I copied the database to another computer and now it is not working the the computer I moved it to. Both computer have the same software.

Thank you

[Dal Jeanis]

Okay, one subject at a time.

1) Is there only one accounting code per county, or does the user have to select one from a list?

2) Is the accounting code box bound to an underlying field, or unbound?


Note - back up your database early and often, and always do testing and development on a junk copy.

[CT_AccessHelp]

1. There are multiple accouting codes per county.
2. Yes

I have many backups, I went back to my laptop and the copy I have there updates the accounting code when the county is changed. When I copy the database to my other machine it reacts as described in my last post. If I Click refresh, it updates.. Hmmmm odd.

[Dal Jeanis]

Hmmm. If there are multiple possible accounting codes per county, then on update of the county, you need to blank the value for accounting code, requery the accounting code dropdown, then mark some kind of hidden "error" field in the form and highlight the accounting code dropdown to make the user choose one. Blank the error field when a value is selected.