Transition from listbox to datasheet

bigalpha

Registered User.
Local time
Today, 05:17
Joined
Jun 22, 2012
Messages
415
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:
Code:
Private Sub Form_Load()
    
    DoCmd.Maximize
    
    Me.SearchResults = Me.SearchResults.ItemData(1)
    Me.SearchFor.SetFocus
    
    
End Sub
 
To use a Form is Datasheet View you just need to assign the Record Source for the Form and apply Filters accordingly.
 

Users who are viewing this thread

Back
Top Bottom