Passing Data from on form to the next

[tpowers]

I am still new at this, and I was wondering if some one could help me with this question. I have two forms. the first form is a read only form and the second form is an up date form. what happens is the user will view the read only form will have the option to add follow up notes to a record. my question is how do I take the data that is on the first ready only form and pass it to the data that is on the up date form so that all the user has to do is add the update notes.

Thank you in advance

 

[KenReay]

Hi

I assume you are openning the second form withDoCmd.OpenForm?

DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]

Either set an approriate wherecondition, or use openargs

Or

Why not use a tabed form, and just have one form?, lock all athe controls you want to be readonly using the .locked property Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[tpowers]

Hello KenReay, the only reason that I would not use the tabform is because I need to be able to have multiple follow ups on one record, my question for you is, what is a "openargs" I am new to all of this so sorry if I am asking to many questions.

 

[KenReay]

Hi

OpenArgs is a parameter of the DoCmd.OpenForm (see syntax in earlier post). It allows you to pass a string of data to the form which the DoCmd is openning. The passed string is available in the on open event of the 'new' form, using the .openargs property of the form (eg inParam = me.openargs).

Hope this helps

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[karassik]

You could use a tabform, but in the update area use a continuous form. That way you would be able to update the original record many times.