displaying a recordset

[mattl72]

Hi

Does anyone know if there's a way to display a recordset from the code on the form? I am doing a SQL statement that selects Order and Item from a query:

strsql = "SELECT Query1.ORDER_NO, Query2.ITEM_NO FROM Query1 LEFT JOIN Querys ON Query1.ITEM_NO = Query2.ITEM_NO WHERE (((Query2.ITEM_NO) Is Null))"
Set db = CurrentDb
Set rs = CurrentDb.OpenRecordset(strsql, dbOpenDynaset)

I want to be able to display the records to a user so they know what records they need to update.

Any help would be appreciated

Thanks,
Matt

 

[LittleSmudge]

How about create a subform with ORDER_NO & ITEM_NO controls and have it set up in Continuous view

Paste the SQL string directly into the subForm's RecordSource.

Place subForm on your main form in a subForm control


QED.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D