LookUp Sync for three part form

[txgeekgirl]

I am creating a Software Library. It has a form which needs the Software Title [Title], Version [Version], and a subform for all of the details based on Version.

I need the Title to sync and make the Version list. Title is a combo box Lookup. Version is a list box. EX. Title = Microsoft Office and I want 2000, 2003 and 2007 to list in the Version List Box.

Then based on a selection there, let's say 2003, all of the licenses and activation keys with links to .pdfs will come up in a data table in License Subform2.

This code is in the After Update based on Title selected. But I think I have a logic error.
=[PBCCUpdateFormQuery]![Version]="[Titles]![Version] FROM [Titles] WHERE [Titles] = '" & [Title] & "' ORDER BY Titles.Version"

Based on Title select from the Title Combo Box, Version will populate the List box below. Then based on selection in Version, License Subform2 will populate.

Any help is greatly appresciated.

 

[ajetrumpet]

To me, your explanation is very tough to follow. Can you perhaps explain a bit more of this to us?