Hello,
This is really my first attempt to do anything beyond what's easily dragged/dropped from the ribbon, so hoping to get some basic advice geared toward the novice that I am.
I currently have:
- A main form called "Main"
- A subform in a main form called "Bills_Rights subform", which is based on a junction table called "Bills_Rights". There's a one-to-many relationship between the main form table (called "Bills") and the Bills_Rights table.
The subform table has a combo box field where one can choose from about 60 different text options (which itself looks up the options from a third table). It also has a whole bunch of yes/no fields that I can't fit nicely on the subform in datasheet view.
I'd love to have just the combo box field showing in the subform and when you click it, another form pops up with the related ID field from the main form/table appropriately filled in. I've created another form based on the same table as the subform (Bills_Rights), which would be what gets displayed on the on-click event.
I found this post: https://www.accessforums.net/forms/o...orm-18891.html
...but could use an even simpler explanation (that post doesn't look resolved anyway). I figure this is handled in the Event tab in properties when I click on the combo box field in design view, but I'm not sure whether I should be doing "code builder" or "macro builder" ... also not sure how to make the values pass to the popup.
Any advice for this newbie? I appreciate any help!