Recent content by Steven

Hi ChrisO, Thx for your reply, it finally worked :-) Greetings, Steven.

Hi John, Thx for your reply, but this is not what I am looking for. I just need the code to give the checkbox the value TRUE, so that it is checked, if the lookup gets the value TRUE out the table. There are loads of people having troubles with this, but I can't find the answer. Maybe anyone...

Hi all, I have a subform with Unbound CHECKboxes. When clicking them my table is updated correct. The problem is that when I open the subform the next time for the NR on the head form, all my CHeck boxes are set to FALSE, but I want them to have the value that is stored in the table. So I...

Hi Chris, Thx for the explaination, learned again a few things ;-) It can be confusing writing a period as decimal seperator and seeing the comma in the table. And I put the Str after the AND, this way I don't need an extra space. Thx again and good luck, Steven.

Hi ChrisO, Thx for your answer, it solved the problem. Only needed an extra " " at the end, because else he added the number on the where, something like "0.8674463WHERE" and access doesn't like that. But it sucks that they still haven't resolve the old , and . problem in the regional...

Hi all, I got an error that says Syntax error, but what is wrong here. If I use a MsgBox on Totaal4 then I see the correct number. If I use only the statement after the ELSE that works fine. Private Sub GrootteExplGeb_AfterUpdate() Dim SQL As String Dim Deel4a_MR As Double...

I have solved the problem

Hi Khalid, It still isn't working good. Because if you go to the next record on the main form, you see that the subform holds the choices of the previous record. But it must be refreshed everytime you go to a new or already existing record on the main form. Greetings, Steven.

Hi All, I want to update a record in a table from within a subform. This "Frm_Projecten" is my master form and I want to use this key "PROJNR_SK" to match it with the same key on the subform. What am I missing here. Thx in advance, Steven. Dim SQL As String If LooptijdProj > 150...

Hi Khalid, It worked good, the only thing I needed to do was to unquote the ELSE statements, because else the next record on the form has the same greyed out boxes as the last one that has been filled in and that is not as mented, because the new subform record get a standard with some things...

Hi Khalid, Thx for your reply. Tomorrow I will look at the code, it is too late now. About your comments, I now some have a lot of columns, but this meant to be. The forms are just questions to be answered, every enty in the forms are needed for calculations and the final results will be saved...

Hi Khalid, Here is the database. Just open Frm Projecten. And look in the subform that is also opened. Fill in the main form and then play around with the subform. You see that all the checkboxes are working and greyed out. Now when you have filled in some of the fields and then close the...

Hello Khalid, Thx again for your reply, but what I mean is: Someone fills in my form and subform On the subform Question 1 contains checkbox A, B, C and D. If he chooses A then the others B, C and D are greyed out and if he unchecks A then all are normal again and can be choosed. This works...

Hello Khalid, Thx for your reply. My checkboxes are attached to a column in a table. Greetings, Steven.

Hello All, I have a subform with checkboxes, if I click one then the others are greyed out, this works fine, but when I close my form and open it again, then it shows all the check boxes again, they are not greyed out anymore. What code do I need to leave them greyed out. Thx in advance for...