Issues with variable pathnames

[maya]

I'm not particularly experience with visual basic/ms access, so go easy on me



I'm trying to write a function that opens a new form and sets certain values to those of the old form (specifically an identification number). I want both the new form name and the old form name to be arguments of function. However, I've run into problems trying to put the new form name variable into the form "path."

I'm going for something along the lines of:

Public Function ChangeForms(NewForm As String, OldForm As String)
DoCmd.OpenForm NewForm
Forms!NewForm!ID = Forms!OldForm!ID
DoCmd.Close acForm, OldForm, acSaveYes
End Function

However, in the third line NewForm and OldForm are interpreted as strings, not as variable names, so I get an error saying that the form "NewForm" could not be found. Any suggestions for how to solve this problem?

Thanks!

[pbaldy]

Try

Forms(NewForm)!ID

or

Forms!(NewForm)!ID

I can't remember offhand if you need the ! or not.

[maya]

It works without the bang. Thanks so much! BTW, I've been reading a lot of ms access forums, and your comments are always very helpful. Cheers!

Maya

[pbaldy]

Happy to help Maya, and welcome to the site! I didn't think it needed the bang, but I lost confidence and added the second one. Should have trusted myself.