Other way around.
Here's how it works.
First page is Insert page.
CID is set by taking the value from a form on a page that you do not have. CID is used to pull a recordset from DB1 to populate the Insert Form and ultimately a record in DB2. Works perfectly.
However, Insert goes to Detail page, where I still need the CID.
The code setting the CID on the Details page was added AFTER I found that my initial CID was being wiped out.
The workaround I came up with this morning was to insert a form at the bottom of Detail with one hidden field, populated from the WADA_Recordset and then Submit the form which loads Results page which pulls data from DB2 based on the CID. Works, I just don't like the form button at the bottom. The regular Results icon generated by DataAssist would be cleaner.
Thanks for your input.
