I'm trying to create a form that allows for the use to specify an ID or use a combo box that I have provided for them to filter results from 2 tables and display them to a list box I have beneath it. Now I have extremely limited knowledge of SQL however I can easily understand the concepts the problem I have is I have no idea where to begin with this.
My goals are:
1) Allow a user-defined variable (ID) to limit the results that post to the list box
2) And/or allow their selection from the combo box to do the same as #1
Current problems:
1) I don't know how to have the results of the query post to the listbox in the form I've built, and allow it to update itself without reloading the form/query
2) Currently when I try to type anything in the user-defined ID box nothing appears, and I have already tried setting Criteria within the query with the:
~ Like "*" & [Forms]![Form1]![ID] & "*" ~
Forgive me for any simplicity involved, I am already well aware that 99% of my issues at the moment are PICNIC related ;D
Any and all help or pointers appreciated, for I feel like I'm in the deep end of the pool and I really could use some water wings.