link form

[eddy3459]

hi all,

not sure how to do this...i have a form where i entered information
about clients info and when finished i click a button to open another
form. this second form is based on a query opened as data entry form in
which one field "clientID" is a lookup field, to be filled with data
from previous form "client_info".

if i link the 1st and 2nd form by using string WHERE criteria, the 2nd
form opened with all relevant data from previous entry whereas i just
want the client info filled in, the rest is entered by user.

i tried assigning the clientID field from 1st form to a public long
data type variable, and opened the 2nd form based on value of that
public variable, but when i click the button the 2nd form opened with
clientID field blank, when i close and open back the then only the
clientID field is filled with data.

my question is on what event should i put the code in 1st form,
on_click event of a button or before update event of a form, my second
question is whether it is safe to use public variable in thios
situation, more so if the application is multiuser application.

TQ...any help is greatly appreciated

 

[eddy3459]

i finally got it working ..thank you

perhaps somebody could shed some light on the safety issue of using
public variable...or perhaps it could have been done some other way