Replies

Trudi,
Thank you very much for the information. It worked exactly as you said it would. Now the relationship window shows two one to many connection link lines one on top of the other. I proved, I think, that the two links are parts of one combined link: deleting one link (line) deleted them both. (Incidentally, while I would have liked to see from your .mdb attachment if your example looked like what I have, I was unable to open it. It seems that when Access 2002 opens an order DB for the first time it has to be able to write to it. I got an error saying that the DB was read only.)

Thanks again, John

Problem is solved. By substituting the Boodmark statements (with their reference to RecordsetClone) with the Filter statements, I thought I had thrown out all ADO/DAO stuff. I hadn’t. I invertently left the same reference in the MsgBox statement. When I removed the reference and just used “MsgBox Me.txtWorkName”, everything worked right.

Thank you both very much for your time and effort. I’ve learned a lot of what not to do.

John Littell (Florence, Oregon)

Thank you again for your continuing attention.

I took your advice and threw out the two bookmark lines of code and replaced them with:

Me.Filter = “txtCompCd = ‘” & Me![cboCreaterNames].Value & “‘”
Me.FilterOn = True

Remember, these two lines (in cbo_AfterUpdate() in the MAIN form to set the current record in the One table) plus the single MsgBox line (in txtWorkCode_GotFocus() in the SUB-form to display the code that is clicked) are the only lines of code left in the entire project. I

That was quick. I agree with you. The combobox, the one-to-many table and the main form have nothing whatsoever to do with this problem. I included them in the description so that you could see how Access uses the Link Child Fields and Link Master Fields to fill the sub-form. There is no code in either form concerned with filling the subform. And the Record Selector, all positioning and all controls mentioned my numbered steps occur in the sub-form. The only code in the entire sub-form is that MsgBox shown.

Thanks, John

Thank you again for your attention.

To questions one and three: There are two tables in a one-to-many relationship; the one

Thank you for your reply. At the prospect of trying your patience, let me expand on the second question (the last sentence of my original). A tabular form is displaying several rows. For VBA programming reasons that don

Thanks, Kevin, for the thought and effort you put into your solution.

John

Thanks, that was a good push.

Your advise to use the recordsetclone proberty seems like the best solution. I am relearning VBA (last used V1) and it seems simplest to confine myself to the newer ADO model. While the help system documents both DAO and ADO Clone methods, I can find no mention of ADO recordsetclone property support. Can you point me in the right direction?

You are absolutely right. This item is closed. Thanks.