I'm trying, within an Access 2000 database, to write a query that will call records from a table and populate a form. The form is sort of "general purpose", a collection of textboxes and pulldowns. I will write code to populate those boxes with the data from the query.
Normally, I would think the record could be selected by the ".(field)" or ".(column)" selection in the returned record.
The problem is, I cannot seem to get the database to accept the DoCmd.RunSQL(string) instruction. It seems to not understand which database I am trying to use, and I don't know how to tell it which database is in use.
I have done this before in VisualBASIC, using tables that were created in Access for storage, but that's a whole different animal, where declarations happen in the "main", libraries are set up, etc., etc. But, how this is done in Access escapes me.
Anyone know how to do this?
Normally, I would think the record could be selected by the ".(field)" or ".(column)" selection in the returned record.
The problem is, I cannot seem to get the database to accept the DoCmd.RunSQL(string) instruction. It seems to not understand which database I am trying to use, and I don't know how to tell it which database is in use.
I have done this before in VisualBASIC, using tables that were created in Access for storage, but that's a whole different animal, where declarations happen in the "main", libraries are set up, etc., etc. But, how this is done in Access escapes me.
Anyone know how to do this?
