GetID function

Hi,

I am trying to create a function that will get an ID from a form and pass it into another form on open etc.

I have 4 forms that view information from the same table (tblRequests), but i am using self joins and the 4 forms show the levels
of information linked by the ID and the Parent ID.

I need to be able to open a form 'ActivityAdd' and depending on which of the 4 forms above pass the ID into the 'ActivityAdd' form.

I have tried to create a function to do this called GetRequestID() but i am not sure what i should be using, as all 4 forms have different names, and so queries etc do not work, as i may have all 4 forms open at once to view the full hierarchy of information.

Any help on this would be great, as i am really stuck.

Thanks

Mezza1

Post a sample of you db and I will fix it for you

Thanks i have sorted this now.