Originally posted by hammbakka
Does your Query return only and always one record so that you want to put the result on the form?
I use always a CratingTableQuery then I have my result in a table, then you can go through the table using a RecordSet and put your result on the form something like that:
where rs is a record set containing your table (Resulting from the a CratingTableQuery )
1. Convert your query to TableCreating Query. Let the table be T_Results for example
2. In the form_Open event you can write thís code:
Dim db as Database
Dim rs as RecordSet, sq as string
sq="SELECT * FROM T_Results"
set db= currentDB
Set rs=db.open(sq, dbOpenDynaset)
rs.close : db.close
set rs=nothing : set db=Nothing