G
Guest
How do I put a Date Column in my subform after it has already been created?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
While in design view, click on the Fields icon on the toolbar. You should
see the new field in that list if it has been added to the subform's
RecordSource. Drag the field name onto your subform.
Also, don't use Date, Item, Name, etc. as the names of fields. They are
reserved words in ACCESS, and can create serious confusion for ACCESS and
Jet. See these Knowledge Base articles for more information:
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763
see the new field in that list if it has been added to the subform's
RecordSource. Drag the field name onto your subform.
Also, don't use Date, Item, Name, etc. as the names of fields. They are
reserved words in ACCESS, and can create serious confusion for ACCESS and
Jet. See these Knowledge Base articles for more information:
List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266
Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763