Recent content by bensonince

Hi, Your correct, my statement didn't make much sense. sorry. I'll try again. I have a select query in my access DB. If i set the rowsource to that query it will populate the Listbox perfectly. How ever i have a parameter that needs to be passed to my query which seems to mean that the whole...

Hi, Rowsource can only excpe the Query without the parameters. I don't won't to write the SQL directly into the forms, All the SQL should be handled by the database so it can be transferable in the future. Cheers,

Furhter information Hi, I have managed to get this far as it would appear addeding a parameter to a query makes things really difficult (very strange), any way this is what i have. Dim db As Database Dim qd As QueryDef Dim LstEvent As Recordset Set db = CurrentDb Set...

Hi, Refernce information: An access 2003 database, all work is internal to the project in access. I have created a query that is a simple select statement with one parameter. I would like to be able to populate my listbox with the information the query returns, How do i call the query (with a...

Hi, I have created a query that is a simple select statement with one parameter. I would like to be able to populate my listbox with the information the query returns, How do i call the query (with a parameter). I can set the rowsource to the query but this doesn't allow me to pass through a...