Recent content by MarkSimm

Sorted, thanks dudes. ) Mark

I have a combo box on a form and I want to be able to change the value list items depending on certain user events. I need to know.... Can you clear all of the list elements in a combo box (so it is empty) in the forms VBA script? Can you add string items to the list in the forms VBA script...

Works just fine, and I get it now. Thanks for the help. Mark

Thanks for that. You are an Access god! ) I tried it and it worked. That is not the whole problem however... I now want to extend the current WHERE statement to filter on another field, so currently we have... "Creater = '" & strTeam & "'" ...I want to also filter the records where the...

Hi, hope someone can help, I have a front-end form with a combo box (called ‘Combo_Team’), which also has a button on it. When the button is pressed I run the following piece of code on the click event… Private Sub BTN_Forms_ToDoLists_Click() Dim strTeam As String Me!Combo_Team.SetFocus...