L
Lodewijk Olthof
I have a form (frmDocuments) which can show all documents made in 2002 and
2003. De names of the documents are someting like 2002001, or 2003001. A
document can be selected by choosing its name out of the combobox
(cboReference).
Now i made a command button which shows 2 selection boxes 2002, 2003. I can
choose one and click the command button again. Then the macro checks if
there is a selection made and if som, filters the form by doing
DoCmd.ApplyFilter , "lngName like '2003*'"
forms!frmDocuments.AllowFilters=Tru
The problem is that in the combox still documents with 2003 are showing (of
course). How can i change the settings of the combobox?
Is it also possible to get a popup form when clicking the command button
from which a can choose the year fields?
2003. De names of the documents are someting like 2002001, or 2003001. A
document can be selected by choosing its name out of the combobox
(cboReference).
Now i made a command button which shows 2 selection boxes 2002, 2003. I can
choose one and click the command button again. Then the macro checks if
there is a selection made and if som, filters the form by doing
DoCmd.ApplyFilter , "lngName like '2003*'"
forms!frmDocuments.AllowFilters=Tru
The problem is that in the combox still documents with 2003 are showing (of
course). How can i change the settings of the combobox?
Is it also possible to get a popup form when clicking the command button
from which a can choose the year fields?