Recent content by wally

I do. Its a form with information on in that if one cell is changed the other cells must me changed or left blank. The before update seems to do that well, unless there is something I'm missing... :?

Nevermind I added a Me.Refresh and it works! Thanks!

That meant to say it works well when applied to the afterupdate.

Thanks for the reply. It created an error when i applied it to beforeupdate. This now created another problem however... If the user changes the field to a new value it clears all the values in the other combo boxes like it's supposed to, but if the user then changes it back to the original...

I have 4 drop down combo boxes in my form. The other three update when the first one is changed erasing the value in the field. The problem am having is... when the user click on the dropdown list, if instead of clicking the arrow again to close the dropdown list they click the same value that...

Found this one too: =DateDiff("yyyy",[DOB],Now()) Any way to add days and months to that?

Tried this and it doesn't seem to work either... =DateDif([DOB],TODAY(),"y") & " years " & DateDif([DOB],TODAY(),"ym") & " months " & DateDif([DOB],TODAY(),"md") & " days"

I already have a date of birth field named DOB. I am trying to calculate age with full years, months, and days using the control source in a text box, but all I can get in return is the calculated years old and nothing else. Here is my code...

Worked perfectly! Thanks!

Thanks for the reply! Is there a way to pull that information from another form or table so I don't need to have a check box on the F_Log form to make it work? I am hoping to make this form as simple as possible; all the user is entering is an animal training session with notes and some other...

I am fairly new the using Access and seem to be stuck on something. Here is the code I am working with: SELECT T_Keepers.KeeperID AS Expr1, T_Keepers.FirstName & " " & [LastName], T_Keepers.DepartmentID AS Expr2 FROM T_Keepers WHERE (((T_Keepers.DepartmentID)=Forms!F_Log!Departments)) ORDER BY...