filtrer formular på 2 felter samtidigt

i mit formular hoved har jeg to comboboxe som jeg pt godt kan filterer på èn ad gangen.

Me.Filter = "Gruppe = " & Me.Gruppe & " AND Type = " & Me.Type
Me.filteron = True

Hope you see the idea

if i throw in a little more point would you then be able to explain me how, I can add a choice to a combobox based on a table?

lets see what we can do WITHOUT extra points :o)
You can place a combo box on the form using the combo box wizard! You will need two combo's one for gruppe and one for type.
Then you add a button to the from and in its on click event youi place the code I gave in my last answer. The field names need changing to the correct names!

creating the combo boxes based on tables isn't my problem and, thanks to you i'm now able to filter on both at the same time. but i would like to add a choice on top of both combo boxes "All" value = 0. How can i do this

I dont think you can!
I suggest that IF the field is empty the this is the same as ALL.

Example:
'This way you can filter on1 or both or even NONE of the Fields


Dim sFilter as string

sFilter = "1"

If len(me.Gruppe) > 0 Then
  sFilter = sFilter " AND Gruppe = " & Me.Gruppe
end if

If len(me.Type) > 0 Then
  sFilter = sFilter " AND Type = " & Me.Type
end if


If sFilter = "1" The
  Me.filter = ""
  me.filterOn = False
else
  Me.Filter = sFilter
Me.filteron = True
end if

dm013>hows it going?

got it right hours ago, but i thought that i had already accepted your answer. sorry!!

no problem, and thanks :o)