Hi All,
There are a predefined functions like MoveFirst, MoveNext etc. in Access. Nevertheless, I've a problem...
On my Form1 there is a ListBox. I click on the ListBox, a new Form2 opens and I've to TextBoxes: Name, Number (values taken from the ListBox - see below).
Now, I want a MoveNext-Button to move to the Next Name, Number (the next record in the ListBox).
I assume, the difficulty is because the two TextBoxes are unbound? Am I right? Do you know how to solve this problem?
My Code (Form1):
Private Sub cmdEdit_Click()
DoCmd.OpenForm "Form2", acNormal
Forms!Form2!Number = lstNS.Column(0)
Forms!Form2!Name = lstBC.Column(1)
End Sub
There are a predefined functions like MoveFirst, MoveNext etc. in Access. Nevertheless, I've a problem...
On my Form1 there is a ListBox. I click on the ListBox, a new Form2 opens and I've to TextBoxes: Name, Number (values taken from the ListBox - see below).
Now, I want a MoveNext-Button to move to the Next Name, Number (the next record in the ListBox).
I assume, the difficulty is because the two TextBoxes are unbound? Am I right? Do you know how to solve this problem?
My Code (Form1):
Private Sub cmdEdit_Click()
DoCmd.OpenForm "Form2", acNormal
Forms!Form2!Number = lstNS.Column(0)
Forms!Form2!Name = lstBC.Column(1)
End Sub
