Search results

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

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

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

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.

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

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.

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

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"

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.

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

wow! your brilliant! Thx for your efforts.

your correct too!

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/

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

i understand you have made codes more efficient by putting do while loop and sum12, sum24, sum 36 that has allowed many lines to right off. Brilliant and thanks again.

you absolutely nailed it! Its brilliant idea to have "If" statement with EOF to exit the code. Thanks a ton!

I am trying to correction as per the suggestions made and will revert back meant while thanks everyone for replying me.

I am getting said error in case when my loop is hitting situation having no data in table feild, i have searched on net and found that i need to insert if statement to check the set value is null. I tried but I am unable to find solution, see if anyone can help .. Thx in advance Private Sub...

I have checked the code and it does not have to so anything with it, it was that i have to make "allow additions" property to yes, i have done that before but I am surprised how it didn't work than. May be i did something wrong before. Sorry for taking out your valuable time.