sub form issues (1 Viewer)

bigmac · Jan 6, 2019

hi all can you help please , I have a subform with two fields [weld standard] and one [weld code] every time the subform changes i.e number of rowes I want to be able to look at value in [weld standard] and depending on value change the value in [weld code] for each row , I have tried this code

If Me.Welding_code.Value = "IX" Then
Me.weld_code.Value = 2
and put it on the after update of the [weld standard]and works ok but I need it to look at each row , look at each [weld standard] and change [weld code] value .
ant ideas please

CJ_London · Jan 6, 2019

include it in the rowsource to your subform as an additional field

bigmac · Jan 6, 2019

how do I do that please?

arnelgp · Jan 6, 2019

use the form's After Update event:

Code:

Private Sub Form_AfterUpdate()
With Me.Recordsetclone
   If Not (.bof and .eof) then .movefirst
      While Not (.eof)
          If !weld_code = "IX" Then
             .Edit
             !weld_code = 2
             .Update
          End If
          .MoveNext
       Wend
   End If
End With
End Sub

bigmac · Jan 6, 2019

hello arnelgp, how nice to hear from you again , this still does not work mate

CJ_London · Jan 6, 2019

assuming your rowsource is a table name, you need to change it to a query - e.g.

Code:

SELECT *, iif(welding_code="XI",2) as weld_code
FROM myTable

sub form issues (1 Viewer)

bigmac

Registered User.

CJ_London

Super Moderator

bigmac

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

bigmac

Registered User.

CJ_London

Super Moderator

Similar threads

Users who are viewing this thread