Transition from listbox to datasheet (1 Viewer)

[bigalpha]

I'm using the Search form that's provided in the code repository; it's working fine. I am trying to transition from a listbox to a datasheet subform instead for a little more flexibility in the formatting.

I see that .itemdata is for listboxes, but what is the datasheet equivalent? Tried searching, but didn't find anything.

Here's the section of code:

Private Sub Form_Load()
    
    DoCmd.Maximize
    
    Me.SearchResults = Me.SearchResults.ItemData(1)
    Me.SearchFor.SetFocus
    
    
End Sub

 

[GinaWhipp]

To use a Form is Datasheet View you just need to assign the Record Source for the Form and apply Filters accordingly.