Dependent, non-bound, combos and record browsing

[ShanePresley]

I know dependent combo boxes have been covered, and I have that working. My problem is setting the values when the user browses records.

I am building a data dictionary app and I have three entities 'Data Package' (database), 'Data Group' (table) and 'Data Element' (column). In this particular form the user will map one Data element to another to establish a source/target relationship. The form looks something like this:

cmbSrcDP cmbTgtDP
cmbSrcDG cmbTgtDG
cmbSrcDE cmbTgtDE

txtSrcDE_ID txtTgtDE_ID

The DP is a 'SELECT *', the 'DG' is dependent on the DP, and the 'DE' is dependent on the 'DG'. The 'DE' combo boxes populate the txtID fields which are bound to fields in the mapping table.

When browsing the records, the text boxes update, but how can I work backwards to set the DP, DG, and DE recordsets and default values. It seems that I would have to:
* find the DP (database) of the DE (column)
* set the default value of the DP combo
* then Requery the DG(??)
* set it's default value
* requery the DE(??)
* set DE's default value.

Does anyone have any examples of this being implemented? Specifically, setting the default value from a query.

Any help is appreciated.

Thanks!
Shane