Navigation Buttons Stop My Code

[millerdav99]

Well I am learning Access on my own which has turned out to be quite the task. This is my first post here.

Anyway I have a bunch of list boxes on my forms, when you click one, it updates the list in the next listbox. The code is working when I initially pull up the form. The code is linked to the AfterUpdate event of listbox1 and is in the module for the form the controls are on.

After I hit any of the generic navigation buttons the data in the 2nd listbox no longer changes. Eventually I want to put my own navigation buttons, but I was just trying to get that listbox update to work first.

Any help would be appreciated.

[RuralGuy]

How about posting the code you have in the AfterUpdate event of ListBox1? Don't forget to use the code tags (the # button in the advanced bar).

[millerdav99]

The first list box is called List84 and the second is LstIssues

Private Sub List84_AfterUpdate()
 
   Dim strSQL As String
   strSQL = "SELECT [tblQuestionsProblems].[" & Forms![frmCallRecordEntry]!List84
   strSQL = strSQL & "] FROM tblQuestionsProblems;"
   Forms![frmCallRecordEntry]!LstIssues.RowSourceType = "Table/Query"
   Forms![frmCallRecordEntry]!LstIssues.RowSource = strSQL
 
End Sub

[RuralGuy]

Okay, now what is the RowSource of the List84 ListBox?

[millerdav99]

The rowsource for List84 is tblmachinequestionsproblems. It is a field list.

So the fields from tblmachinequestionsproblems are the data for List84, then in each column is the data that will display in LstIssues

[RuralGuy]

Uhhh...I have no idea what tblmachinequestionsproblems is. Is that the name of a table? What does "It is a field list." mean?

[millerdav99]

tblmachinequestionsproblems is a table. It is the rowsource for List84. The row source type of List84 is a field list. The fields from the table tblmachinequestionsproblems are what fills List84.

In tblmachinequestionsproblems under each field is information that will go into LstIssues.

When the form is displaying record 1 in its source table, the list boxes work correctly, if I navigate to a different record they do not work.