Alternate Form Navigation Paths

[acannon]

I have a form, Form A, which has a number of command buttons to navigate to other forms using the onclick events. Form B is one of those and contains general information about an item. Foms C - H are other forms accessed from Form A which allow entry of details that vary depending on the type of item. The normal navigation has been to always return to Form A and then navigate to another detail form. My users have requested to be able to navigate to C - H from B also. There is a field in Form B that allows using a Select Case structure to navigate to the appropriate C - H. What I need is a way for the detail forms C - H to know if they were entered from Form A or Form B and return to the one from which they were entered. This alternate return path has me stumped. Can someone please help me? I consider myself either an advanced beginner or a beginning moderate user/programmer.

Thanks,
Alan

[pbaldy]

One option would be to use pass the "from" form in OpenArgs, which could then be used when returning.

[ranman256]

If you go from A (list) to B (detail) then the query for form B is for ALL records BUT the code in A filters it. docmd.openform "frmDetail" ,,"[id]= " & me!ID

Do the same with the other forms, open then next form using the WHERE clause in the openform.

[acannon]

Thanks, pbaldy! The OpenArgs use solved the problem!

[pbaldy]

Happy to help!