Search results

Changing How Combobox Functions Based on Form's Editing Mode? ("Add" vs. "Edit") Hey all, I'm not sure if this is a feasible possibility, but is it possible to change the value of a control on a form (i.e., a combobox) depending on what mode a form is opened to? The combobox that I have...

Hi all, Thank you so much for your feedback! I just realized that I didn't put up a post for what I finally agreed to do with this database... but I took out the "None" condition (the equivalent of Combo177 in the database), just because it was a redundant condition. That said, I've finally...

...I hate to admit it, but although the advice written here so far is sound for other purposes, it doesn't appear to be applicable to this particular case. I know that, despite looking through a lot of websites telling me what openargs are, it hasn't come any closer to showing me how they...

Hey John, If I understand this correctly, this code will loop for ALL controls, so that the if/then loop is related to every control, right? (There's no way of being selective and only applying the if/then loop with some controls?) (Sorry for asking so many clarifying questions -- I just want...

Hmmm... I guess all of this makes sense. However, I'm wondering -- if I have an if-then loop which can enable/disable controls on a form, how would I reference that loop? I know I'm missing some fundamental VBA basics with this, but how do you parameterize (or 'tie' a variable name to) a...

I've attached here an updated database with various implementations of a combo box or an option group (where each control, ideally, can put multiple values into a single field in a table). I don't know if I did this correctly, but I was just curious to see what the better implementation...

Alright, so as a (quick) update: I decided to see what would happen if I decided to put in an option group into the form. I created a new field, where a single option group (using checkboxes) was placed. I coded the previous comboboxes to be a single option group, with one number linked to...

Hm, everything that's been posted so far has been tremendously helpful - thank you, everyone! Unfortunately, I'm not sure if I simply have tunnel vision towards a particular layout, but I don't think a single option group would be applicable in this context. As far as I've been able to tell...

Alright, I'm going to bite -- what exactly is an "option group"? (I'm looking at the Microsoft help sheet for an "OptionGroup Object", but I'm not sure what exactly it's telling me.)

Hm, alright. So if I understand this correctly, OpenArgs has to be used in BOTH when the form is being opened and when the form is being loaded every time someone switches from one form to another? So, if there are three forms, OpenArgs has to be used twice? Thank you for the feedback! I...

For what it's worth, these are the sources I used so far in these forums to look up openargs: Pass Current Record OpenArgs Passing recordset in OpenArgs Using OpenArgs to Pass a Variable's content

Hey all, Although I have a general understanding of the openargs property, I'm still confused on if openargs can be used over multiple instances, between multiple forms, in the case that a form is indirectly passing parameters to another form, a couple of forms down the line. As I have it in...

For further reference, I might shut off some of the fields in the case of someone answering a particular case, using the .Enable property. I'm still trying to think through the logic of answering the combo boxes, and wanted to see what would be more intuitive for a user to use. PS: congrats...

Hey Bob, You're correct in your assumption. Here are all the permutations that I tried to account for with the four combo boxes: If the first three combo boxes are answered first: If someone answered "No" for Combo171, Combo173 and Combo175 in the example, Combo177 automatically defaults to...

Hey Bob, Thanks for the information. In reality, all the fields in the table and the controls in the forms do have meaningful names that make sense in the context of the overall database. In the interest of stripping down the database down to the bare bones, to essentially show what I was...

Hey all, I'm not sure if this type of thing has been answered before, but I've looked at most of the available cascading sample boxes on Google, but nothing's really worked for my question so far. (In fact, I'm not even sure if this fits under the typical definition of a "cascading combo box"...

Greetings from Pittsburgh! I'm brand new to Access, in that I've only used Access 2007, and have only been working with it over the last couple of months as part of a project or two with my work. I'm usually pretty adept at picking up programs, but there's been a certain point with Access where...