Combo Box selection is not saving Record?!

[dlab85]

Hey Everyone,
I have a chemical log in form that does what I want visually, but have hit a Mental Roadblock on the performance of the function I want. Attached is the form, and my relations between tables, with tblChemicalInfo and tblChemicalID the main focus of my question.

The user selects a catalog number from the combo box labeled "Catalog Number". That combo box has a row source that queries all catalog numbers in the database (per setup with Combo Box Wizard). After user selects catalog number, I have an AfterUpdate macro to requery. The query is for the information direction below the combo box, my Chemical Info (Which is a form). This form's record source is a query with all the fields from tblChemicalInfo, and critieria on Catalog Number based on selection in the combo box "Catalog Number". This pulls up the appropriate information for the selected record, which helps pre-fill the LogIn form for the user. BUT, when I continue to enter the information in the fields to the right of the Chemical Info (which are forms based on tblChemicalID, tlbLocation), it creates my ChemicalID (autonumberd PK for tblChemicalID), but doesn't save that record under the selected Chemical that the user selected. I tried having the query display both tblChemicalInfo and tblChemicalID to see if that would tell access to add the FK ChemicalID to the Chemical with that Catalog Number. I feel like this should have been an easy shoe-in, and have once again tripped myself. Any help would be appreciated. Thanks!

[June7]

Is combobox labeled "Catalog Number" an unbound control?

Don't understand data structure.

If you want to provide db for analysis, follow instructions at bottom of my post.

[dlab85]

Nevermind June7. I figured it out. I just needed some form rearrangement. It seems that when I happen to get stuck, usually just explaining my situation helps my brain comprehend the multiple steps I have taken, and results in a solution (most of the time . Marking thread as solved!