You are here:
Tony, The recordsource of the form is probably a query that does not include these fields. Check out the form's record source property and see if it includes the two fields. Bob Heifler MyAccessProgram
=Format(Date() + Choose(Weekday(Date(),vbMonday),1,1,1,1,3,2,1),"dddd") To test this Substiture a Date value for Date(). For example: Format(#11/20/09#+Choose(Weekday(#11/20/09#,vbMonday),1,1,1
First, you need to understand how Access stores DateTime values. Access stores date/time values as a double precision number where the integer portion is the number of days since 12/30/1899 and the decimal
If I follow you, you have two tables in one to many relationship. What's not clear is which is the one and which is the many. But these tables should NOT have the same primary key. They should both have
I would not use a combo in this case. I would use either an Option Group or a Check box. But the process is the same no matter what control you use. In the After Uodate event of the Status control

©2009 About.com, a part of The New York Times Company. All rights reserved.