arcticsponge
VB makes me crazy
- Local time
- Today, 18:42
- Joined
- Oct 20, 2009
- Messages
- 12
Hi All, This has probably been answered elsewhere but I cannot find it. I have 1 query & 3 forms. I am trying to perform user searches of the query, but my SQL is appalling. Basically, the first form acts as a homepage (in that it is always active); it has an unbound textbox (for the search terms) and an option group: The user types in the terms and selects the options: op1 (searches columns 1-3), op2 (column4) op3 (col 5) & op 4 (col 6) The results of the search are to be displayed in an unbound listbox on the second form, of which the user double clicks and the record is opened on the third form. I am stuck.