How do I select data using a data adapter with value from a list box in Access?
I have the following:
Public Function getGuestData(ByVal strParameter As String) As DataSet
'Fill the dataset
DsGuests1.Clear()
daGuests.Fill....("Select * from Guests where Phone = '" & strParameter & "'")
daGuests.Fill(DsGuests1)
Return DsGuests1
End Function
What should the daGurests.Fill statement look like?
