VB6, access95 database.
Existing code: Form1.Data1.RecordSource = "Select*From Table Where Jones like '" & Form1.Text1.Text & "*'"
This works fine. My problem...Can I refer to a field name in a listbox, replacing the field name (Jones) above.
In other words, what would be the proper syntax for "Select*From Table Where form1.list1.text like '" & Form1.Text1.Text & "*'"
I hope I'm making myself clear.