[AccessD] One form for all

That works! Thank you. First time I ever tried anything like that. Never
really knew how the openArgs worked - learned something.

Va.

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Monday, March 17, 2003 6:01 PM
To: Hollis,Virginia; accessd at databaseadvisors.com
Subject: RE: [AccessD] One form for all


On 17 Mar 2003 at 7:45, Hollis,Virginia wrote:

> What do I do if it is a new record they are adding to Form 3? When a new
> record is added using Form 3, the RequestID (FK) shows 0. I need it to
enter
> the same RequestID as the opening form, whether it is Form 1 or Form 2.
> 
> Form 3 needs to open and set the FK - (RequestID in Table 2) to the same
> RequestID (PK in Table 1) as in Form 1 or Form 2.
> 

Use OpenArgs to pass the RequestID from Form1 or Form2

Then in the Before_update():

RequestID = OpenArgs


-- 
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg