Query Result in Variable

[key]

Hi Access-Friends,

I'm asking myself for 4 hours how can I run a query and save the result in a variable? I'd like to place it in the Form_Open event, because the user shouldn't notice that).
The variable is Boolean.

Could someone give me a small/big hint how to do it?

Many, many thanx in advance.

Key

 

[cogent1]

It would help if you posted the query. You will probably have to express your query as an SQL statement in a function.

 

[key]

The query is pretty simple...

"SELECT ID.Indicator FROM Table1 WHERE ID=" &Me!cboList.Column(0)

Many, many thanx

Key