Sql kode - fra tekst til tal

You can access all of the columns in the combo.

Me.NameofCombo.Column(0) is the first column in the combo

Mybe didnt quite understand the problem :-(


you can convert  text to other values. EG a text to a Long (integer)

CLng("123")
123

Is the column in the table numerical, if not you should convert it.

The thing is that I have 2 combos:

1) The first with the 'Alle' function.

2) A second where the value from no 1 should return a list within a 'Afdeling'

The me=...... only returns one line were it should return a number of lines - so it dosn't work.

If no 1 is 'Alle' then there should be no filter on no 2. And if something is choisen in no 1 the list should describe that 'Afdeling'

I'm going to be away for the w/e otherwise I'd take a look at your dB.
Heres a link which explains how to filter the contents of one combo depending on value chosen in another.

Your obvioulsy going to have to take into account "alle"

http://support.microsoft.com/default.aspx?scid=kb;en-us;289670&Product=acc2002

Dont mind waiting for next week. Have a nice weekend.

Thanks. You can maybe send dB to ekspertenATsanthell.dk
AT = @ and I'll look ASAP

you have a good w/e too

I've changed the filter in the query you use in the activity combo to [Forms]![frm_Hovedmenu]![frm_Økonomien].[Form]![Afdeling]

dont forget to close :-)

thanks