Recent content by pasin

You mean it is showing empty values because it is also listing records with empty values from the result in the subform? The years combo will always show 4 values in any situations. Its values will not depend on other combo values

Thank you so much, it is working like a charm. One last question. When I fill all combo boxes with a value from the drop down. If i go again to the last dropbox and I want to select another value, it is showing no values at all, just blank. I am sure I am doing sth wrong> pleas if you have a...

As soon as I click on Data button I get an error : The expression you entered refers to an object that is closed or does not exist. The error refers to line TransForm.Init Me.frmDataSubform.Form, SUB_RECORDSOURCE & " WHERE (1=0);"

It is summing column Lab1 and Lab2. So there is a total lab for every row. You can see it in the subform Data Tab where is the sql created.

Thanks, It is working now for the save issue, but there are some calculation columns that now are not working like Tot_lab. It is showing #Name? Also I had a total row in the end of the records that is not working too. If you could check also this issue, you'd help me a lot.

I removed the Unload event on main form but I also have to comment the line of code I mentioned above in order for the combo query to work. When I click the X icon , while I filled one record with data , I get a message Do you want to commit all changes? I click no but the record added is saved

Please click on DATA when you open Form. Thanks

Thank you very much. It works. But I am not sure why I am getting a problem. The form has some combo box . When they are filled , the subform shows related records based on combo choosen values. Now that I put your code , when I choose combo box values , they are no reflected on the subform...

The start and commit transaction must be coded on the form or on the subform?

Actually nothing is saved at all, even if you click outside or the save button

Hello everybody. I have a form with a subform. The subform is a datasheet. I am trying to put a SAVE button on form ,so that records entered in subform are saved only when you click the button on the form. I have create a hidden text field in the subform called buli which holds true or false and...