Pull up a record from a table based on values selected from cascading dropdown menues.

[halabis]

I have a table from which I want to be able to pull specific records (all fields in the table "Occurrences"), by selecting a name and date from a drop down menu. The names list needs to exclude duplicates, and the date field needs to only populate dates available under that given name. I am pulling the names from a completely different table ("Agent") to eliminate duplicates, but selecting a different name from that dropdown is not pulling up new records, but rather changing the value in the first record on the "Occurences" table. As I havent been able to get even this first step to work, I havent been able to move on to using the second dropdown to select the record corresponding to the correct date.



I have found several tutorials for similar issues, (this thread: https://www.accessforums.net/forms/p...elp-52414.html) but it doesn't quite do what I need it to do.


Thanks!

[pbaldy]

If the combo is changing the name in a record, it's bound to a field in the data; it shouldn't be. It should be an unbound control separate from the one displaying the value for the displayed record.

[halabis]

Thanks! I have unbound it, but now selecting a new name in the drop down does literally nothing other than changing the name in the drop down

In my date search query I have "AgentName" and "OccurrenceDate" filtered with "[Forms]![OccurrenceEdit]![CboAgentName]"

[pbaldy]

Is the form/subform based on the query? You'd have to requery it for the changes to show.

[halabis]

Ok, I have set them both to Unbound, I have added language to refresh the query after each selection. The issue I am running into now is that the query is not properly pulling the data.

The Agent Name dropdown pulls from the "Agent Name" field from the "Agent" table. This gives me a list of all the agents listing them once each. It is functioning properly.

Next I have a query to pull "Agent Name" & "Occurrence Date" from my "Occurrences" table. "Agent Name" has the "[Forms]![OccurrenceEdit]![CboAgentName]" set as a Criteria so in theory when the query is run, it will only pull the "Occurrence Date" values where the "Agent Name" value matches what is in the drop down. Unfortunately no matter what I have in the drop down the query is coming back blank.

Thanks.

[pbaldy]

Can you attach the db here?

[halabis]

Unfortunately I can not, it has sensitive employee information in it.

[halabis]

After more investigation, the error seems to be in the criteria pulling from the Form. The first time I open the query after freshly opening the DB I get a pop up asking what is in the form, regardless of what is actually in the dropdown, and if I manually type in an agent name it pulls properly. It just isnt pulling it from the form itself. Every other time I run the query it no longer provides the pop up box and the query comes back completely blank.