Copy Value to Form

[mtagliaferri]

I have a form which is inserted in another form, by double clicking on a specific field it opens a 'Help' form with a list of parameters; I want to double click on one parameter (Field) and copy that value to my previous form in the field I have double clicked.

I have the following code which obviously is not working :banghead:

Private Sub CrewRoleCode_DblClick(Cancel As Integer)
    Me.Refresh
    If Not IsNull(CrewRoleCode) Then
    Forms!frmDuty!sfrmFlight![SM Crew Assigned].Form!IDCrewMember = Me.PositionWorked
End Sub

 

[theDBguy]

Hi. It may be hard to say why that code is not working without seeing it in action. Are you able to post a demo version of your db with test data?

 

[vba_php]

I have a form which is inserted in another form, by double clicking on a specific field it opens a 'Help' form with a list of parameters; I want to double click on one parameter (Field) and copy that value to my previous form in the field I have double clicked.

it really should be as simple as:

forms!yourFirstFormsName!TheFieldInTheFirstFormYouDoubleClicked = me.PositionWorked

unless of course, you are trying to copy the value to a SUBFORM that is nested inside your main form? if that's the case, the syntax become a little more involved. give ur code:

Forms!frmDuty!sfrmFlight![SM Crew Assigned].Form!IDCrewMember

it looks like u might be trying to do that?