to change a query field's value using Lbox selection

[Frank72]

Hi All,

i'm trying to run a report from a button , the query the report is based on i want altered by a selected listbox(2 in fact) can i use the where condition in the macro to achieve this?, i've tried already and its giving me a blank report and just wanted to know if it was possible

recordset clone?, bookmark? any of these come in handy?

also how would i open a query to manipulate it in code ie instead of dbOpenTable is there a dbOpenQuery equivelant?

thanks a million

frank