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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
drop-down with null?
Thanks for the tips. I've modified the query that populates the combo-box which essentially adds the “none” value via a union query: SELECT Project_Descr, Project_ID FROM ProjectList UNION select "", null from ProjectList ORDER BY Project_Descr; Limit to List = Yes This gives the...- tredeker
- Post #4
- Forum: Microsoft: Access Forms
-
drop-down with null?
All, I have a very simple form with a drop-down populated by a query. When the form first opens, the drop-down is empty. After opening the drop-down, the list of values appears as it should. What if the user does not want to choose any of the values and would rather leave the drop-down blank...- tredeker
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Passing parameter to a report
works like a charm --- thanks!- tredeker
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing parameter to a report
sorry...the second paragraph should read "...reports do not have the OpenArgs property". I'm currently using the OpenArgs property in the form_open section.- tredeker
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing parameter to a report
All, I've created 2 forms: 1st form lets user select filter criteria and 2nd form appears with record details using the OpenArgs to set the SQL where clause. I want to do the same, only show a report rather than a form. The catch is that forms don't have the OpenArgs property. How do I pass the...- tredeker
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
