need help calling a form

[Rafael T]

Hello

I'm new to access 2002 and vba but here is what i want to do.

I would like to have form with two fields in where a user can put a form
name and a field name. Also add a button when clicked, open the form the
user opened and insert a message into the field (the user wanted)

I have tried:
'formName as the field for the form name
'fieldName as the field for the field name

'
Forms!Me!formName.value.Me!fieldName.value ="hello there"

but i does not work, is there any way to do it?

thanks
RT

 

[Nikos Yannacopoulos]

Rafael,

Try this:

Forms(Me.formName).Controls(Me.fieldName) = "hello there"

HTH,
Nikos

 

[Rafael T]

Nikos,

Thanks a lot it worked very well.

Rafael

Rafael,

Try this:

Forms(Me.formName).Controls(Me.fieldName) = "hello there"

HTH,
Nikos