[AccessD] One form for all

Virginia

...there are 2 ways off the top of my head 1) use the openargs to pass the RequestID 2) or use an ifthen in the onopen of form 3 to determine whether form 1 or 2 is open and set your filter accordingly ...probably other ways as well but HTH :)

William Hindman
"And so, my fellow Americans: ask not what your country can do for you - ask what you can do for your country. My fellow citizens of the world: ask not what America will do for you, but what together we can do for the freedom of man." John F. Kennedy, 1961
  ----- Original Message ----- 
  From: Hollis,Virginia 
  To: accessd at databaseadvisors.com 
  Sent: Monday, March 17, 2003 7:44 AM
  Subject: [AccessD] One form for all


  Form 1: A form that is used for requesting services  - a data entry form.
  Form 2: Used by the engineer to edit, update data from the request.
  Form 3: Additional data form needed to open for the User & Engineer

  The table has a RequestID as the PK
  A second table is used to store additional data, with the RequestID as FK.

  I need Form 3 to open from either Form 1 or Form 2. How do I set the RequestID FK to the PK RequestID on Form 3? I placed the FK on Form 3 and set the default to =Forms!Form1.RequestID. Of course this will not work on Form 2 because the default value for RequestID references Form 1.

  I do not want to create multiple forms to do the same thing - but if that is the only choice I will. How can I have Form 3 open from Form 1 &/or Form 2 and set the RequestID?

  Virginia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030317/1628f43b/attachment-0001.html>