Passing a value from a form into the current field on an open form

[tuniwes]

I'm struggling on achieving this
I have a sub-form open and want to double click on a field(datasheet view) to open another form of bitmap images.....no problem in doing that

Then depending on the image clicked on the second form I want to pass a text value back to the field on the original form.

Currently going around in circles, any help would be much appreciated

Thanks

Ian

[June7]

More than one way to accomplish. What have you tried? Post code.

[tuniwes]

Hi June

I have a form called inspection_form that is a subform in datasheet view with a field called feature

On the dbl click event of the value field I am opening the form that contains the bitmap images called bitmaps

On the dbl click event for a bitmap I tried

Option Compare Database


Private Sub Command7_Click()
Forms![inspection_form]![feature] = "test"
End Sub

Access reported an error couldn't find the referenced form inspection_form


Thanks

[Minty]

That's because it is a sub form. You need to reference it as per http://access.mvps.org/access/forms/frm0031.htm

Forms!Mainform!Subform1.Form!ControlName

[tuniwes]

Guys,

As always, fantastic the way you help those of us who are struggling.
Working fine now thanks so much for your help!

I will mark as solved

Best

Ian