Search results

That's it! I made one small change to the row source to select the account number instead of the autonumber ID and it works exactly like I wanted. I thought I tried that but I must have been trying to make it more complex than it is. Thanks theDBguy!!

Thanks theDBguy; I'm hoping it is easy and I've just missed it somewhere. Attached is a quick example. In the form, I want to show the name of the parent, instead of the ID. I have to step away for a while but will check this when I get back. Thanks for your help!

Hi Ranman256, I think I understand what you are saying but I'm a little confused on the 'report' table concept. Would that also allow entry of new records?

Hi theDBguy, I don't quite understand. If I bind the combobox to the ParentNumber field (a number), then it shows the number value of the parent. So, using the chart of accounts example, the form would display values of 110, Cash, 100 for Number, Name, ParentNumber. But I want it to show 110...

Hi all, Apologies for the confusing title; I wasn't sure how to explain it succinctly. Here's what I want to do: I have a table with 3 (relevant) fields - Name, Number and ParentNumber, where ParentNumber is a value of Number on another row of the same table, and I want a form to show the...

It took me a while to understand this and I do like the solution a lot. I'll have to play around with it as some of the code is new to me and while I see 'what' it does, I'm still working through understanding why; but this seems to be a better approach. Thanks for the example and for taking...

Thanks MajP! A multiselect list box is an interesting idea that I hadn't thought about. I think that would be acceptable, if it works in this scenario. I'll have to dedicate some time to your other post to understand it a little better. I'd prefer not to fake the MVF but I would like to have...

LOL, good point.

I think I'm closer, but still not sure how to get around it. In the data entry forms where this works, the form is bound to a table that stores an ID for the 'child' combo box value (bound to a column on that table) but the 'parent' combo box is unbound (the parent ID is a FK on the child...

Hi theDBguy; thanks for the quick response! I'll give that a try. I tried stripping out almost everything; I even went back to the test version of the DB that you helped me with last week and just added the code above but even that one crashed. I'll work on recreating it tonight. I feel a...

Hi All, I have a form with a few combo boxes that will allow the user to select values and then a subform will return results that are restricted based on the user's selections (more on that in this thread...

My mistake - in the demo DB, Pere named his subform combo box the same name as the table column and I incorrectly assumed that "Regions.Value" referred to the Regions combo box, not the Regions column in the record source table. I got confused because he used "States" for the column name in the...

You did it again; thank you! This gets me over the hurdle. I'm still confused how it worked in Pere's demo DB when the criteria variable used the combo box and the version you have the variable uses the table column, but I will try to build off of this rather than recreate what he did...

Here's a demo version of the database. The form in question is frmResponseQuery. There are only two records in the notes table at the moment and only the Industry combo box has any code. Changing the value of the Industry combo box to/from Energy or Government should filter/unfilter the 2...

I'll do that shortly; just need to clean up a few things. I'm sure this is it, I just don't understand why it doesn't understand in my case but it worked in the other demo.

I don't think this is it. Using the demo database from the UA site, I added debug statements to the same code and it resolves to "Regions.Value = 1" and it works as expected there. ("Regions" is the name of the subform control, which corresponds to my cboResIndustry in this case.)

Hi all, I have a form with a subform where there are combo boxes at the top to select one or more values and then filter the records returned on the subform based on the selected values. It uses the same logic/code as the demo in this UA post: Multi Value Fields (big thanks to theDBGuy for...

OK, that makes sense. Not sure how that didn't click earlier but maybe I'm not as far off as I feared. I was getting nervous when something so simple didn't work how I expected. Thank you theDBGuy and zeroaccess!

That works! And I am acutely aware that I am in over my head and what I thought I knew was way off. I thought the me.dirty property was only for existing records. So in a scenario like this, there is never a need to do a SQL insert? I also tried the update and it didn't work either. It...

Sorry! I got distracted and wasn't thinking. frmRegulation_x is the offender. Open that form, which is bound to tblRegulation. You can select a Regulation Set from the combo box, then enter anything in the fields for Regulation, Text and Reference, as long as the combination of Regulation...