Combo Box on Form stalling

[Blkblts]

I have a survey form that runs from a query. When the user chooses a members# in the combo box it filters and gives only the Surveys filled out by the member and allows the user to enter a new survey if they want to. This works!! Here is what doesn't.. When I click on the combo box to choose a different member the combo box shows me the member# but when I click on the member# nothing happens. I have tried to requery the form, but this does not seem to help.

Thanks in advance

kim

 

[Jack Cowley]

I am a bit confused about just what is happening with your combo box. It works once but not a second time? Is the code that filters the data in the After Update event of the combo box?

 

[bill crumpton]

I believe that you need to check the bound coulumn property of the combo box. If that option is not bound to a unique identifier (i.e. the primary key of the table) then you will only get the first selection in the combo box if the there are two selections that are equal in value. For example, if your combo box is a list of last names and there are two smiths in the combobox. Unless the bound column is the unique identifier of each smith you will only be able to choose one Smith.

HTH
BAC

 

[Blkblts]

Thanks Bill, I have slept since I posted this but you are correct. My primary key was based on two columns to make it unique and I think I was bound to just one of them.

kim

 

[bill crumpton]

Kim,
I am glad this worked for you, if you need any other help just advise.

Bill