Let me demonstrate a small example of my issue in the table below.

ID-A ID-B Name
1 23 First
2 26 Second
3 Null Third

The control source for the form is Table B, which has ID-B, since I want the Row source to move there with corresponding other text fields. I also have unbound text fields which use the corresponding ID-A field to fill corresponding information from Table A....

Im a rookie.

I have am unbound combo box populated with values (rowsource) from a query which has 2 tables in it. Each table has its own ID, but both are included in the combo box (info3). Sometimes the combobox has ID values from Table A, but the corresponding ID value in table B is NULL. The bound column is the ID from B, because I use it to populate text boxes, by going to that record using:

strCriteria = "[ID]...