Search results

  1. L

    Getting selected record from "Search Part" pop up form to main form

    From post above: So the button is on the form I want to close... The name of the form is "ProdSrchFRM"... The code I have fails on the DoCmd.Close - what on earth am I doing wrongggggg Also not sure where that line should be to allow the Else bit to do it's bit...
  2. L

    Getting selected record from "Search Part" pop up form to main form

    Can anyone help on how to close the form?
  3. L

    Getting selected record from "Search Part" pop up form to main form

    Please delete it
  4. L

    Getting selected record from "Search Part" pop up form to main form

    Pps. The code works fine without the DoCmd bit...
  5. L

    Getting selected record from "Search Part" pop up form to main form

    Okay, got the thing to work but have 1 (hopefully) SMALL problem... I need to use VBA on click of a button to do it - But I had been using that button to close the form via a macro. I hate to admit this but I have NEVER (despite trying) managed to close a form using VBA. So the button is on the...
  6. L

    Getting selected record from "Search Part" pop up form to main form

    I am so :poop: at this :rolleyes: thanks for all the help 😘
  7. L

    Getting selected record from "Search Part" pop up form to main form

    I know this is a bit of a sad question but ... how do you get all the emojis? I can only do a smiley face which gags me!!!
  8. L

    Getting selected record from "Search Part" pop up form to main form

    Hey I think it's his hobby - no hassle - Thank you for the naming conventions & hints n tips - working on it now (arghhh!) I'll let you know if I get there :)
  9. L

    Getting selected record from "Search Part" pop up form to main form

    Hey! Thank you :)
  10. L

    Getting selected record from "Search Part" pop up form to main form

    Thanks Gasman :-)
  11. L

    Getting selected record from "Search Part" pop up form to main form

    No idea what or where the Query GUI is - giving up for now ... got to pull user instructions together - they'll just have to put up with my inadequacies :-)
  12. L

    Getting selected record from "Search Part" pop up form to main form

    Not convince that's how you spell woose :-) , whoose, wouse?
  13. L

    Getting selected record from "Search Part" pop up form to main form

  14. L

    Getting selected record from "Search Part" pop up form to main form

    I'm still doing something wrong - If you have a main form (which is not involved at this point), a subform & a sub sub form (which is in datasheet view & which has an unbound combo box filtering it) how would you get the current record selected in the sub sub form datasheet to the sub form in...
  15. L

    Getting selected record from "Search Part" pop up form to main form

    Sorry should have replied to this all code compiles fine untill this line of code is added...
  16. L

    Getting selected record from "Search Part" pop up form to main form

    Sorry had to delete the customer details - even so the file size is too large to upload...
  17. L

    Getting selected record from "Search Part" pop up form to main form

    Hi, the database compiles fine apart from this wee bit of code - not switched off - I'm just not switched on in how to use it :-)
  18. L

    Getting selected record from "Search Part" pop up form to main form

    That works :-) duh! Thanks but the only options it gives are the name of the button the code is in and ActiveControl, AfterDelConfirm etc - would send a screen shot but it disappears on nip! The pop up form is Product Search, the sub form datasheet I'm selecting from is named Child1, any idea...
  19. L

    Getting selected record from "Search Part" pop up form to main form

    Intellisense doesn't seem to be switched on (no idea how) but I copy the field names to notepad and paste from there - the name's okay but could it be that Me. is not recognising it as referring to the ProductID of the selected record in the datasheet?
  20. L

    Getting selected record from "Search Part" pop up form to main form

    Probably doing something stupid but ...
Top Bottom