Search results

  1. S

    Design Thoughts for Sub-Forms

    All, apologies for the lack of response. My Father passed away on New Year's Eve. To say things have gone crazy as a result would be the understatement of the century. I wanted to come back and post my appreciation to everyone who has been kind enough to offer suggestions. I will be returning...
  2. S

    Design Thoughts for Sub-Forms

    Hello everyone (and "Season's Greetings" !)... I'm spending some of the quiet time this holiday period with a little project to create a database from some pretty diverse (and inconsistently structured) data. Specifically, I'm in the process of setting up a simple Access DB that offers a...
  3. S

    Passing Context Between Forms

    Hello everyone, I wanted to come back and offer a follow-up to the post I made on Wednesday at 12:34pm. In that post, you can see that I'd got the basics reasonably straight, but when my second ListBox appeared, instead of showing the data I was expecting, it actually showed the SQL that I was...
  4. S

    Passing Context Between Forms

    MajP, thanks again for the responses and even more so for the example answer. The mock-up you offer is pretty much exactly what I'm looking to do, except on the third screen view, where you have the "Back to Orders" button... Here I don't plan to use yet another formatted ListBox, but a regular...
  5. S

    Passing Context Between Forms

    Firstly - and most importantly - I'd like to thank everyone not only for replying, but for doing so with such useful examples. It's been educational and I am incredibly grateful for the time and effort you have invested! Secondly - and please don't hate on me - I might have come up with "yet...
  6. S

    Passing Context Between Forms

    Hello everyone... I'm trying to do something with forms and sub-forms that I think *should* be possible, but I'm struggling with the implementation. I'll try and describe what I'm trying to achieve in 2 ways - a high level "what I'm trying to show" and then "how I'm trying to get there". Whilst...
  7. S

    Triggering Combo Box Refresh

    Solved: Re: Triggering Combo Box Refresh Thank you... I clearly need to tidy up my code a bit, but I think this solves the problem. I should be able to repeat this invocation for any other forms that might have the relevant combo box populated. Of course, I won't be able to guarantee that those...
  8. S

    Triggering Combo Box Refresh

    Thank you for such a prompt response! Just to clarify your suggestion here... when you write, "Forms!ModParameter!nvpModSelect.Requery" does this basically tell the "Delete" form to "reach into" the "Mod" form and refresh the query on the Mod form combo box? [ I *think* that is what this...
  9. S

    Triggering Combo Box Refresh

    Solved: Triggering Combo Box Refresh Hello everyone... First time post [please be gentle...] I am hoping that someone can guide me to a mechanism that I can use to forcibly refresh a ComboBox content based on a form-related event. Right now I am quite unable to do this, but also 99% certain...
Top Bottom