I would like to insert data from a table into a form using a query as the 

recordset. I am using DAO Recordsets, and have criteria for ContactID, the 

first field in the table. I do not want to add data, only display it on a 

form.

This is a multi-part message in MIME format.



------=_NextPart_000_0020_01C1BB8E.954260B0

Content-Type: text/plain;

	charset="US-ASCII"

Content-Transfer-Encoding: 7bit



Look at my post for RE: Passing Data between forms.  You can use the

same code except for one change:



change   

    DoCmd.OpenForm stDocName, , , stLinkCriteria

to

    DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly







John Ruff - The Eternal Optimist J



Always looking for Contract Opportunities



 



9306 Farwest Dr SW



Lakewood, WA 98498



papparuff@c...







-----Original Message-----

From: Christopher Mohr [mailto:cmohr@b...]

Sent: Friday, February 22, 2002 6:00 PM

To: Access

Subject: [access] Recordsets and queries DAO





I would like to insert data from a table into a form using a query as

the

recordset. I am using DAO Recordsets, and have criteria for ContactID,

the

first field in the table. I do not want to add data, only display it on

a

form.