I have a query that groups the dates in a table so that they can be displayed in a combo, but the records needed are really only the month and the year that a record has been entered in and the recordset produced has the day,<br>so I need to narrow them down and load them into a combo list. In vb this would be simple by using the additem method<br>is there a simalar way in Access? Doing a compare and finding the month is not a problem with a loop but then I want to load them into the list property of the combo
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filling combobox from code
- Thread starter mc13
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
place in your query<br>MMYY:format([yourdatefield],"MMM,YY"
<br>then include that field in your combos row source you can even select distinct to eliminate dupes
<br>then include that field in your combos row source you can even select distinct to eliminate dupes- Status
Similar threads
- Locked
- Question