im sorry for editing the original post. yes i kept stop in the code but couldnt figure out still. unfotunately i swapped the code into my save button and changed a bit now its working. thanks pat.
hi Pat, can you be more detail. i cant get you what you meant about response ? Also i said before my formsbefore update event is not firing all the cases of condition
sorry i didnt get you. but here is exactly
what's happening.
when i open the master form it has 35 fields where i require few fields to get validated as 8 of them. but if i dont press on any textboxes and just press on save button still my records saves as null values in the table. yes my form...
hi, Actually my main reason was the same issue you stated before. my form has many fields and if the user tries to press save button it saves the record. so it skips the validation written in the before update events. i tried with after update still no luck.
why is it that user has to press on...
hi i have stuck in the forms update event where the event is not firing up.
i have to check or validate certain feilds and have to make sure they are not empty in the fields. example i have 8 fields.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Form_Master.Primary_Key)...
hi i have a form which has code written in code module function(x)
now when i try to call this function(x) in my specific module it throws me sub or function not defined !! how can i correct this error? tried by changing it into public and removing private didn't work.
hi pat, this indeed helps. but i tried and it didn't work out for me. when i pressed the save button it saves the record and doesn't check for validation
thanks mark. but when i open the table it shows perry name itself but when i write code in vba it takes 1 as value. so clearly stores ID so my question was why it is not showing 1 as in raw table data ?? why is it showing Perry ??
Thank you all, problem solved actually it was automatically saving the data. but i placed a validation condition in the click event of save button thats why it was not saving automatically.
i have commented the validation then it works smoothly. after that i had two issues.
1. i have so many...
Master table bound to master form
i created a combo box and changed the control source to vendor( which is field name in the master table)
so i have new record button Macro which takes all the data from the combo box also and when pressed save button it saves into master table.
but when i open...
hey actually, i have stated the problem below and exactly what im trying to get from it.
ID Compound structure Ap Bp vendor
As you can see the above one has table with 25 fields in it but I could give you the first 5 fields I have a form where the data will be submitted into the database. Now...
hi i have this problem since i created combo box with three values. Although when i select one value and press save button it saves in the table but if i want to update that specific field from the combo box on change event it throws this error while it also updates after i close this dialog...