K
Khoshravan
I have a text field in my table called "category". In lookup tab in
design view I made it combo box. In a form based on that table I select
category and changed its type to combobox. It asked for source and I
made a query based on category ( I am not sure about this part but I
remeber it asked for such a thing and I made a query. Although now that
I look to query, I do not see anything). Category field in Form, works
fine but brings all my inputs. some of them are repeated entries. Also
it doesn't bring new entries. Only brings entries before I the change
(change the category field to combo box) I want the combox in form to
bring them only once (if they are more than one, summarize them and
bring only the summary in the combo box) Is this possible?
The reason that I want to do this is: I want to make a list of my
categories. At start I have no idea how to establish my categories. In
this way I want to input categories as I go ahead and finally I make
the category list. So I want to be able to input to this field
(category) and in some cases select from it.
TIA
design view I made it combo box. In a form based on that table I select
category and changed its type to combobox. It asked for source and I
made a query based on category ( I am not sure about this part but I
remeber it asked for such a thing and I made a query. Although now that
I look to query, I do not see anything). Category field in Form, works
fine but brings all my inputs. some of them are repeated entries. Also
it doesn't bring new entries. Only brings entries before I the change
(change the category field to combo box) I want the combox in form to
bring them only once (if they are more than one, summarize them and
bring only the summary in the combo box) Is this possible?
The reason that I want to do this is: I want to make a list of my
categories. At start I have no idea how to establish my categories. In
this way I want to input categories as I go ahead and finally I make
the category list. So I want to be able to input to this field
(category) and in some cases select from it.
TIA