Search results

  1. N

    Command Button Event Procedure Error

    Hello all, thanks very much for your help with this - all suggestions made are very helpful and much appreciated :) I was trying to put the command buttons on a subform, instead of actually editing that form... :rolleyes: ...it's one of those things that seems obvious that it'd cause a...
  2. N

    Command Button Event Procedure Error

    I was just about to post that exact video :) My problem is the second one this chap has - God, this is a minefield!💥 Again, thanks for pointing me in the right direction! 👍
  3. N

    Command Button Event Procedure Error

    Hi Bob, that would be handy - I don't get the wizard that the woman on this video gets when she adds a button, though - my version of access (Office 365) just dumps a button on the screen and calls it Command75 or similar... I'm hunting through the UI for it, though...
  4. N

    Command Button Event Procedure Error

    Thanks; I hear what you say - the navigation bar confuses the intended users, though, so I'm using simple command buttons to make the navigation more obvious. The error handling in the event procedure will just warn the user that the first/last record has been reached. The error attached to...
  5. N

    Command Button Event Procedure Error

    Hello, I suspect this is just me not knowing what I'm doing (again), but... I have a form, which has a subform on it. In that subform, I have two command buttons, which I'm attempting to turn into navigation buttons by adding the following code into their OnClick events as [Event...
  6. N

    Cascading Listbox Controls

    Thanks very much for taking the time to explain that - I think I appreciate the difference between a text string that simply sets a value and one that has to execute - I can see why it would have to be a piece of procedural code rather than just a string on a property sheet, now. Thanks! 👍
  7. N

    Cascading Listbox Controls

    Thanks Bob! ...although, I have to admit, my first response to it working was "Ha!..I...er...oh...I thought that's what I was already doing." I know I should go and read a book/help-file to find this out, but could you possibly explain what the difference is between me just typing into the...
  8. N

    Cascading Listbox Controls

    Hi Bob, thanks for your help with this. I am, indeed, putting my code in the controls property sheet, not the form code module - I want the second listbox to update only when the first listbox is changed, not when anything else on the form happens - clearly, I haven't really understood how...
  9. N

    Cascading Listbox Controls

    Hello, I'd be very grateful for some help, here. I'm floundering about in Access, based on what I can remember of VB and SQL from twenty years ago, so not a good start... I have a form which has two ListBox controls on it - the first, lstModule is populated from a local database when...
Top Bottom