Passing values between forms 1

[h3lm3t]

Hey there thanx for looking, i need some basic help.

I built a form based on one table, i only want the user to navigate through this form. I bult another form in design view so that when the user clicks ADD new record, the second from comes up and allows them to enter values for a single record.

My problem is, how do you pass the autonumber primary key value from the original form out to a text box in the second form ?

Also, does the same apply when passing any type of value i.e. text etc.

I though about using a variable to store the data then filling the second form with the variable, but is there a better/easier way of doing this ?

Thanx in advance for any and all help
regards

h3lm3t

 

[Rolliee]

send me your email and I will send you a sample of how ot do this. The last guy said it cannot b e done and I will not argue with the troops on Tep_Tips.

rollie@bwsys.net

 

[h3lm3t]

Hi Rolliee, thanx for the help.

helmet@blueyonder.co.uk

cheers
h3lm3t