Using Docmd or something else to query table

  • Thread starter Thread starter Mr. JYC
  • Start date Start date
M

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?
 
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.
 
Back
Top