Using Docmd or something else to query table

[Mr. JYC]

Hello,

I have an issue with my Access 2000 database. I have a form with a subform
in it. Since I have a subform, I am unable to open a connection
consequently, unable to open a recordset. There is a fix but I am not going
to implement this.

I want to find another way to populate a number of text boxes using fields
from a query that will return only one record from a table. There seems to
be some Docmd methods that could do this but how do I have the results of the
query (single record) sent to each text box?

 

[Graham Mandeno]

Hi Mr JYC

I don't understand your question. There is no problem in Access 2000 which
would prevent you binding a subform to a recordset based on a table or
query.

Please elaborate.