Databases
StackOverflow2013
Postsdbo
POMS Access. ADO recordset for subform. Child relationship set up programatically. Won't automatically fill in field
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMS Access. ADO recordset for subform. Child relationship set up programatically. Won't automatically fill in field
    primarykey
    data
    text
    <p>I have a form/subform for inputting data into an ado table. The main form's recordset is a local table of Widgets and information about the widgets (WidgetID, WidgetName, size, color, location, etc). I am inputting test data (multiple tests per widget, all with unique dates) through the subform which is connected to an ADO recordset to a table called Tests. I have a combo box, findWidget, in the main form where the user can choose a WidgetID and it updates some info on the main form. I have also written VBA code to do the job of the parent/child relationship to change the recordset of the subform to only show the Tests that correspond to that WidgetID. However, There is a field for the WidgetID in the subform that I would like to be filled in automatically when i choose the WidgetID in the main form. This just worked before I applied the ADO recordset (i was using two local tables), and I set up a parent/child relationship. However, with ADO it seems parent/child doesn't work so I have to vba it. Here is the code I have tried, this is for when the subform loads:<br> <code>Private Sub Form_Load()<br> Me.UCI = Forms!InputMainForm.findWidget<br> End Sub</code><br> The code executes with no errors, but the control in the subform is not updated. It is just blank upon loading the form. Maybe the code should be in the after update of the findWidget combo? I dont know. If I put it there I'm not really sure how to refer to the controls of the subform. Any ideas?<br> Thanks.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMatt
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMS Access. ADO recordset for subform. Child relationship set up programatically. Won't automatically fill in field
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat makes you think you need an ADO recordset? Why not just set the subform's Recordsource to the SQL you were using to create the ADO recordset? Then the parent/child link of the subform object would take care of populating the FK in the subform. Seems to me you've created your problem by not doing things the standard Access way, so I'd like to hear an explanation of why you believe you need to use an ADO recordset.
      singulars
      1. POMS Access. ADO recordset for subform. Child relationship set up programatically. Won't automatically fill in field
      1. USDavid-W-Fenton
    2. COthe simple answer is my boss told me to use ADO. Before i was "linking" the tables from our SQL database. In order to do this I had to have the ODBC connection established on my computer. I believe that the idea behind using ADO instead is that you dont have to set up the ODBC. This way we can pass the mdb on to any employee and they can use it straight from their desktop. And I cant just refer to it through SQL. There has to be some connection set up first: either a linked table or an ADO connection.
      singulars
      1. POMS Access. ADO recordset for subform. Child relationship set up programatically. Won't automatically fill in field
      1. USMatt
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload