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
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.