Combo Box Trouble

[Guest]

I have two tables (A) and (B). In table A the user inputs a date. In table
B I have a combo box where you can choose the date listed in table A.
However I get duplicates of the same date. How would I get rid of these.

Also I have the user input a number in table A. In table B a combo box
lists the numbers but they aren't in order (i.e. 1-50). How would I be able
to put these in order.

Any help would be greatly appreciated.

 

[Guest]

The recordsource for the combo should be a query that way you can create a
"distinct" set of records which will hide duplicates. For the second one the
same story make a query and use a sort in the query on the numberfield.

I wouldn't advice any dataentry through tables though and suggest you place
this on a form.

hth