Thank you for the formulas. That is kind of what I want to do. Except if you are using the form in the Early Table you go to IMGFolderQ but if you are using the form in the Midday Table you go to IMGFolderH. It wouldn't be an if/then from the same form.
My problem is I'm not very familiar with programming and don't know how to specify which form to use in the formula. The formula I found
URLRoot() & "db/" & [_DBID_BUY_OUTS] & "?a=API_GenAddRecordForm&_fid_77=" & URLEncode ([Record ID#])& "&z=" & Rurl()
will only take me to the default form. Other than the form id number, I'm not sure how to differentiate between the two forms. And I don't know the terminology to modify the formula to say use this form instead using the form id number. Any help with that?
Thank you for your help. I hope I'm making a little sense.
------------------------------
Brianne Jacobsen
------------------------------
