Search results

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.

SHANEMAC51 and Mike Krailo, Thanks for your reply also typo in subject is corrected, sorry for that. I understand now that there is allow edit property has issue and its obvious because of the coding. . . I will try to find the culprit code by elimination process and will revert to close this...

No nothing in table is added, besides the issue is that nothing appears in subform that means i cant enter any data. Please check the database is attached. В таблицу ничего не добавляется, кроме того, проблема в том, что в подчиненной форме ничего не появляется, что означает, что я не могу...

its Russian and you can translate it with Google Translate.

yes, but same problem remains in default new order button at the bottom.

The issue is in "FrmGreyFabricOrder" Please have a look at it.

I made link while i created both, besides if there is connection issue than how the records that are already entered are showing but only when new records is pressed its getting disappear!

1) I have a form and it has subform in it, 2) When old records are viewed it works fine. 3) The moment add new records is pressed the subform goes non-responsive (shows nothing in it). 4) Tried everything, A) Removed all my codes from both main form and subform, B) Checked...

Thanks! I understood that I should try to use query to get calculated values and use those queries whenever I need them. And I am also curious above reading about Normalization, I will find any material available on that subject however I will be highly obliged if you can provide any link on...

Its working big Thanks! I have to change it a bit to include where condition in update statement. For anybodies interest I am putting it down here. Dim sq, sw, su su = "where TblOrder.OrderID = " & Forms![SubFrm_SubTblGreyFabricOrder]![OrderNumber] sw = DSum("[GreyPurchaseQuantity]"...

Thx!

Thx!