Recent content by KennyUK

Hi Robbo, Thank you for taking the time to reply - Its always interesting and educational to see how you experts do things. I agree with the Inteligent and elegant comment, sadly I have found (maybe due to a lack of knowledge) that the two do not always go hand in hand. Thanks again, Kenny

Hi Michael, Many thanks for your reply and comments. It's nice to see how the experts do things - I certainly have food for thought now. Regards, Kenny

Hi, I just wondered if anyone has opinions on the following or if there is an established "Right or wrong" way of doing things. I am setting various field propertys on a form depending on which button of an option group the user selects. I have discovered that I can do this in one of...

Hi, I just wondered if anyone has opinions on the following or if there is an established "Right or wrong" way of doing things. I am setting various field propertys on a form depending on which button of an option group the user selects. I have discovered that I can do this in one of...

Hi, Heres my problem: I am using Access 2000 and I have a main form, with a subform and on the subform is a further subform. Everything works great, and as the data is entered into each field certain form and/or field propertys are set in code depending on what the user does or selects. What I...

Hi Rich, I may be able to help but first which version of Access are you using, let me know. Kenny

Hi, Heres my problem: I am using Access 2000 and I have a main form, with a subform and on the subform is a further subform. Everything works great, and as the data is entered into each field certain form and/or field propertys are set in code depending on what the user does or selects. What I...

Hi Guys and Gals, Still have not fixed this problem - anyone got any suggestions please ?? Thanks in advance, Kenny

Hi Guys and Gals, Still have not fixed this problem - anyone got any suggestions please ?? Thanks in advance, Kenny

Hi Nick, no you are not being cheeky, its always worth checking these things but let me assure you that I am using the correct combo name. Cheers, Kenny

Lightning, Hi again, Your "dirty" workaround did the trick but its a little frustrating because I hate being beaten by a problem. If the = "" solution worked for everyone else, I am the kind that wants to know why i didnt do so for me - I am stubbon like that. Anyway...

Hi Lightning and michael, Just been messing abnout with this problem and I tried to add a button on the same form as the combo that has the following on the buttons On Click event comboName = "" Access gives the following error: Run Time error '2113' The value you have entered is...

Hey Avery, One thing you could try is an explicit reference to the forms like so: If IsNull([Forms!PCOs!form!COs]!IssueDate) Or [Forms!PCOs!form!COs]!IssueDate = "" Then Only a suggestion but worth a try. Good Luck KennyUK

Hey Nick, Thanks for the reply and suggestion but sadly it did not work. I have also tried comboName = "" and comboName.Value = "" But they did not work either. Anything else I could try ? Regards, Kenny

Hi Lightning, Nope still dont work and I am placing the code exactly how and where you guys suggest - this is most frustrating. Allow me to explain further: I am using Access 2000. I have a form with a sub form. The sub form has 5 combo boxes on it and the main form has 3 (plus 2 text...