Move to next record in subform

D

DW

I am trying to change a combobox's value for each record listed in a subform
I tried;

Private Sub Command10_Click()
line1:
Forms!laborcost.chargelaborsubform!Combo26.SetFocus
If Forms!laborcost.chargelaborsubform!Combo26 = "No" Then
Forms!laborcost.chargelaborsubform!Combo26 = "Yes"
DoCmd.GoToRecord , , acNext
GoTo line1
Else
Exit Sub
End If
End Sub

with no prevail, can you help?
DW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
how to place the cursor in the field of a subform 20
How to add record in Subform which is in another Subform 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Go to a new record on another form? 6
synchronized combo boxes moving between records problem 3
Go to next record or close 1
syncronize two subforms oncurrent events 0

Top