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
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