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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Use Dcount on form filtered with parameter query
Please disregard previous post. I played around with relationships and it seems to be working now (even though I'm pretty sure I put everything back the way it was???) :>) Andi- vtandi
- Post #15
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
Michael, I was so thrilled that the filter was working correctly, I did not notice that the user was unable to edit the form. This even though I have the Allow Edits, deletions, additions and data entry properties of the form all set to yes. It is probably something obvious I have failed to...- vtandi
- Post #14
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
Michael, I can't thank you enough for all of your work on this. I like your form. It is pretty swift. Will probably continue to use the menus because I am going to need them to be able to filter on quite a few other fields. However, I am going to save your version (and the code) for future...- vtandi
- Post #12
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
Michael, I can't thank you enough. The version that I sent you did not have the custom menu bar. Basically, the users will work from the Referral form, the menus will be <Referrals>, <Patients> and <Reports> and the options under these will lead to the unbound parameter selection forms (e.g...- vtandi
- Post #8
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
Michael and Duane, So, I have lost the parameter queries per Duane's advice and am now using a small pop-up form where the user can select their parameter. This morning this seems to be working though last night I couldn't get the unbound lookup field to match the values in the lookup field in...- vtandi
- Post #6
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
Thank you both. I have been tasked with creating a database YESTERDAY. Also, I am a VB novice and have not even made an Access application in over 2 years. So,,,,,rusty. I was hoping to avoid code and use macros. Currently, I am using a custom menu item that runs a macro that: Selects the...- vtandi
- Post #4
- Forum: Microsoft: Access Forms
-
Use Dcount on form filtered with parameter query
In my DB [Referrals] I have a form [FRM_Referrals] that users can filter based a parameter query. I am using a macro with the ApplyFilter command to accomplish this. The problem is that when no records match the user's criteria, a blank form is displayed. I have searched for solutions and...- vtandi
- Thread
- Replies: 14
- Forum: Microsoft: Access Forms
