I can do that by rebuilding the form and using that field correct? My only question is won't that then cause county to be a bound box? From what I understood it had to be unbound for the combo box setup with the location.
I can do that by rebuilding the form and using that field correct? My only question is won't that then cause county to be a bound box? From what I understood it had to be unbound for the combo box setup with the location.
Forget about the combo box.
You just need a text box that it bound to "County" on the form.
You can hide the text box. It just needs to be on the form if you are going to refer to it.
Dale
I will add county from the frm_issue_input, pardon my ignorance but what exactly does that accomplish? Also, do I need to add provider in the same way?
If you want to store a value in County it has to be in the record set of the underlying data of the form.
Access has to know what you want to store and where it is.
Side note: Adding County does not guarantee that you will be able to store County anywhere.
The query may be non-updatable.
Dale
EDIT: This is one of the reasons why we stress table normalization so much.
You can not just pick and chose fields at random to put in a form and have the query updateable.
Ok, I have recreated the form using only fields found in the two main tables that the data will be entered into from said form. I'm not sure how to proceed from here to get the same filter/sort result I had with the unbound combo boxes, but actually achieve the table update as needed. Once again I apologize, I assure you I am well aware I am in over my head on this one, but I have to meet the demands of the project.
OK, what do you want to do?
Dale
All I want is the county selection to filter the locations as in the real table the provider locations has over 1400 records. I want when a county is selected to filter the drop down list for provider locations to only show locations within the selected county. I also need to ensure that it will update in the table when the record is submitted.
Upload your database with the new form.
Dale
database with new form.
IssueInput2.zip
See if this is getting close to what you want.
IssueInput2.zip
Dale
It is closer but I need the entire list of every location that is referenced to that county not just one. And I need county to requery so if I change the county it will pull the right locations for that county not the first one selected. (this is only in case of error on initial selection)
Sorry I was still on my first cup of coffee.
IssueInput2.zip
Dale
It queries exactly as I specified the problem I see now is the same thing I had issues with before, the county nor provider are saving to the tbl_Prob_Report from the Frm_issue_input.
From post 13.
DaleThe problem is that the field "County" is not in the recordset of the form.
I don't think any of the code in the After event is needed.
You have named your combo box County however that is NOT the same as the field in the tbl_review.
Your tables could use some normalizing.
I could get the the data you want into the table using DAO.
This could cause you mountains of problems later.
I would have to have a great deal more information.
It would be a lot easier for you in the long run to fix your tables.
Once you start forcing data into an UN-normalized table with DAO it never seems to stop.
I would be more than glad to do that, but I am not certain what is wrong with my tables to fix them so that this can work. Can you point me in the right direction?