Hello,
I have a search form set up with a combination of bound and unbound combo boxes that populates a subform on the same page to display the search results. When I change the value in the bound combo boxes, it changes the value of that respective field in the first row in the table to whatever I selected (or null if I remove the value from the box). I have done a lot of searching on this issue, but I havent been able to find a solid solution.
I have seen some suggestions for deteting the control source and manually specifying values in an unbound combobox, however, the actual search criteria for these bound combo boxes is the numeric ID, not the actual displayed value. I cannot seem to figure out how to create a value list with 2 columns, hide the ID column, and yet use the ID as the value that gets passed to the query to return the correct results.
By the way, I am an access newbie. I am just teaching myself as go on what has turned out to be a very complex project.
Any help or suggestions would be much appreciated. Thank you.