Recent content by vtandi

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...