query column access via vba

[bigmac]

hello can you help please , is it possible to access a column in a query using vba ?
I have a query that has a lot of tick boxes on it , I do not want the tick boxes to be shown on my form but would like to access them to find out if true or false . cheers

 

[pbaldy]

You can use DLookup() or open a recordset.

 

[bigmac]

thank you for your quick response , can you give me an example please

 

[pbaldy]

Here's a reference for DLookup():

http://www.mvps.org/access/general/gen0018.htm

Searching here should find a large number of threads regarding recordsets. I'd use DLookup() for a single value, a recordset for multiple.