Retreive data from text box and sort

[Carl_and_Earl]

I want to retreive data from the text box "Expirare" and sort that date
descending in the right list box.
Seems simple but I don't know how to do that.
Thanks.

http://img407.imageshack.us/my.php?image=accessia1.jpg

 

[Jeff Boyce]

Data isn't stored in a textbox in Access. Data is stored in tables.

If you want to list dates, use a query to retrieve (and sort) the dates from
a field in a table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Arvin Meyer [MVP]]

Probably the easiest way is to use a query for the list box which reads from
the form, something like:

SELECT tblMyData.DateField
FROM tblMyData
WHERE (((tblMyData.DateField)=[Forms]![tblMyData]![Expirare]));

Then requery when or if you change the textbox.

 

[Carl_and_Earl]

At first, I wanted to do how you told me, but I also wanted the date to be
dd/mm/yyyy type and couldn't do that, so I changed to text.

 

[Jeff Boyce]

Access treats text differently than date/time values. If you want to see a
date/time value displayed as you describe, don't change it to text, just use
the format property (or function).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Carl_and_Earl]

I had already tried formating, but I didn't succeed. Maybe I didn't try enough.

 

[Carl_and_Earl]

http://img55.imageshack.us/my.php?image=wrongky4.jpg

 

[Carl_and_Earl]

http://img55.imageshack.us/my.php?image=wrongky4.jpg
I must be doing something wrong.