I hit a stumbling block.
I am working on a ancestral research type database and I want to link different records together. Here is my scenario so far:
datPrimaryRS is an adoc that is pointing to the Person table.
datNameSourceRS is also pointing to the Person Table. This is used to populate the list in the DBCombo. Now when I double click on the DB Combo I want to move the recordset to the record that matches the boundtext property in the DBCombo. This works fine except when the recordset is sitting at the first or last record in the recordset. In those two cases, the process I designed is broken, it either results in an "unknown error" or it returns back to where it was.
Does anyone have a good example on how to do this?
The method I was using was: ado.recordset.find("[Criteria]=" & DBCombo.boundtext ]).
I surely would appreciate a clue in why this is failing.