Recent content by Andrea

Apologies fro the long delay. I have entered all my information to a table which the form is then linked to. I have added the criteria of the combo box in a querry. Does this help? Andrea

Hi Bob This code does clear the form, however it doesn't then show all my records up again. Any thoughts?

Hi Bob Using the filter would be the easiest option but my boss doesn't want to use the filter box and wants to use combo box instead. I know it sounds silly! Is there a command for clearing the results from the combo box? Hay, I don't even know if I am making sence! Kind Regards Andrea

Thanks for that the combo box is linked to a query and the command box code looks like this Private Sub Command381_Click() Dim query As String Dim Selectedrole As String selectedcountry = Combo382.Value If (selectedcountry = "United Kingdom") Then...

I am sure this will be an easy question for someone to answer. I am creating a database which lists customers contact details. I have a command box linked to a combo box. When I select something from the drop down list of the combo box (e.g United Kingdom) and click my command box, it then...