Note:
i use ado jet and vb6
i have 3 fileds f1, f2, f3
f1 have unique value.
i need to fill textbox2 and textbox3 during ditation in textbox1 baseed the serching in filed1 of access table....
i hope i am be clear:-)
no with autocomplete combobox and text box
-
sal21
- PlatinumLounger
- Posts: 4373
- Joined: 26 Apr 2010, 17:36
-
HansV
- Administrator
- Posts: 78633
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
sal21
- PlatinumLounger
- Posts: 4373
- Joined: 26 Apr 2010, 17:36
Re: no with autocomplete combobox and text box
sorry... digitation...HansV wrote:What is "ditation"?
example:
the user digit 1 show all based 1, the user digit 12 show all based the strictlly value 12...
I think is needed to use Like statement or not?
-
HansV
- Administrator
- Posts: 78633
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: no with autocomplete combobox and text box
You could change TextBox1 to a combo box or a list box with 3 columns. The row source of the combo box would be a query that returns field1, field2 and field3. As the user types, the combo box/list box will automatically move to the first matching row.
Best wishes,
Hans
Hans