Recent content by B99

  1. B

    Solved Combobox Row Source as the Form's Bound Table, Joined to Itself

    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!!
  2. B

    Solved Combobox Row Source as the Form's Bound Table, Joined to Itself

    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!
  3. B

    Solved Combobox Row Source as the Form's Bound Table, Joined to Itself

    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?
  4. B

    Solved Combobox Row Source as the Form's Bound Table, Joined to Itself

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

    Solved Combobox Row Source as the Form's Bound Table, Joined to Itself

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

    Access Crashes When Setting RowSource in VBA

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

    Access Crashes When Setting RowSource in VBA

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

    Access Crashes When Setting RowSource in VBA

    LOL, good point.
  9. B

    Access Crashes When Setting RowSource in VBA

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

    Access Crashes When Setting RowSource in VBA

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

    Access Crashes When Setting RowSource in VBA

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

    Form Filter Not Working; Prompts For Value

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

    Form Filter Not Working; Prompts For Value

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

    Form Filter Not Working; Prompts For Value

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

    Form Filter Not Working; Prompts For Value

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