S
Steven Glass via AccessMonster.com
I have a form with buttons(for each company) on it and when clicked should
bring up another form with data records for that particular company. Each
button represent a company set of records. When I click on a button,
another form opens with data records for that company. When I click on
another button the same form opens but with data records for the new button
just clicked.
What is the best way on load of the 2nd form to change the set of records
on load? I’m also changing the label to reflect the new set of records.
Below is my filter code that I’m using on load of the 2nd form:
Private Sub Form_Load()
Dim sFilter As String
sFilter = "[Companyid] = 2"
Me!HeaderNm.Caption = "ADP - Preview"
Me.Filter = sFilter
Me.FilterOn = Len(sFilter) > 0
End Sub
Thanks,
Steven
bring up another form with data records for that particular company. Each
button represent a company set of records. When I click on a button,
another form opens with data records for that company. When I click on
another button the same form opens but with data records for the new button
just clicked.
What is the best way on load of the 2nd form to change the set of records
on load? I’m also changing the label to reflect the new set of records.
Below is my filter code that I’m using on load of the 2nd form:
Private Sub Form_Load()
Dim sFilter As String
sFilter = "[Companyid] = 2"
Me!HeaderNm.Caption = "ADP - Preview"
Me.Filter = sFilter
Me.FilterOn = Len(sFilter) > 0
End Sub
Thanks,
Steven