I have a query relating to subforms and how the data is stored and accessed.

I have created two forms, A and B. Then I insert B as a subform into A.

Now:

1) I add a record A1, with subform entries B1 and B2. The subform entries are stored as records in form B.

3) When I view A1 or A2 the subform magically shows only those B records in the A record in which they were originally entered, i.e. B1 and B2 show up in A1, and B3 and B4 show up in A2.

Now, what I think is happening is that the subform in Form A (which is of type longlist) is storing a list of the unique ID's for each record in B that relates to that record in A. This is how it knows which ones to retrieve and display.

Am I on the right track or completely misguided?

Now my real question - I want to be able to manipulate which B records show up in which A record. For example, can I also retrieve B3 and B4 into the subform list on A1?

If I am correct that the longlist contains a list of ID's, what I need to be able to do is to add another ID to the list. I envisage that this would link to another record within B. I attempted to use the List.Add functionality, but it was not allowed.

Note that when I am attempting this the record is already present in the B form - I don't want to physically add another record into the list, but link to an existing one (if this is possible).

Thanks,

Jim