Recent content by Ashisht76

  1. A

    Solved Navigation form requery subform

    hi. i will be highly obliged if you could give code for requery a combobox on a form that is in navigation form.
  2. A

    Solved Not allowing user to delete record in subform (datasheet view)

    You nailed it again, Thanks a ton for the help.
  3. A

    Solved Not allowing user to delete record in subform (datasheet view)

    I have been searching for solution on net and found similar issue in below site, Please also have a look at it that might make some sense. If i try to apply it here then according to it I will have to show my query in layout view but I dont know how can i do it with query in Subform/ Subreport...
  4. A

    Solved Not allowing user to delete record in subform (datasheet view)

    HI, Sorry i have to edit my previous comments as i tired it on wrong Form, so the thing is that as i have mentioned that this is query that sits in Form /Subform frame, hence there is no such options available in first place. Please find screen shot of the same. Thanks.
  5. A

    Solved Not allowing user to delete record in subform (datasheet view)

    Hello everyone! Thanks in advance for giving your precious time to read my post. My Form has subform that has its source Record a Query for showing conditional data, the problem is that user can select record and press delete button from keyboard to delete record from that which i don't want...
  6. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    I am closing this one as i have found solution, I have split code in two and one is for before update and rest in after update, that works. If any one is interested in codes kindly let me know, I will be glad to share. Thanks everyone to take your time and put efforts.
  7. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    Hi. Your valuable suggestion was absolutely correct however when i had tried putting codes in Before update event of sub-form, the last entry was not getting updated, hence after your suggestion I have changed the sequence of codes and again tried putting it in Before update and all the things...
  8. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    I had already tried and stumbled upon some issue that i cant recollect at this point, but I have tried it again and it seems it will work. Thanks for your suggestion and finding precious time for replying. If any thing will come up I will update here and if all goes well I will mark it as "Solved"
  9. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    Thanks for information, I will set the warning on again with hourglass. I had read about the danger of doing the same but couldn't fully understood that time. Thanks again for explaining.
  10. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    Hello Everyone! Thx in advance to read and reply my question and thanks to this site for providing opportunity for getting help. I have main form (FrmFabricReceive) and subform (SFrmTblFabricPieceEntry), I have set code in Subform so that if condition not met it will not run update code, But I...
  11. A

    Subform goes blank when add new record is pressed.

    wow! your brilliant! Thx for your efforts.
  12. A

    Subform goes blank when add new record is pressed.

    your correct too!
  13. A

    create a new record in a subform using a button on a form

    Thaks a ton! even after 11 years your still best as no one else could give me precise reply in my question, please find the link. https://www.access-programmers.co.uk/forums/threads/subform-goes-blank-when-add-new-record-is-pressed.321664/
  14. A

    Subform goes blank when add new record is pressed.

    I get your point as I have stumbled once again with same issue.
Top Bottom