I want to put the result of a query into a TextBox (ex. to display minimum price from article list)
How i do :
i put a MyListBox and a MyTextBox on my Form. MyListBox is set to visible=No
Me.MyListBox.RowSource = MyQuery
i run my query and i put the result into MyRecordSet
i go to the top of MyRecordSet
i put MyRecordSet into Me.MyListBox
i copy MyListBox into MyListBox
This is certainly not optimal since i use a ListBox between the query and the TextBox. But i do so because a TextBox has no RowSource.
Putting the result of the query directly into the TexBox should be much better.
Does anyone have a solution for this ?
How i do :
i put a MyListBox and a MyTextBox on my Form. MyListBox is set to visible=No
Me.MyListBox.RowSource = MyQuery
i run my query and i put the result into MyRecordSet
i go to the top of MyRecordSet
i put MyRecordSet into Me.MyListBox
i copy MyListBox into MyListBox
This is certainly not optimal since i use a ListBox between the query and the TextBox. But i do so because a TextBox has no RowSource.
Putting the result of the query directly into the TexBox should be much better.
Does anyone have a solution for this ?
