Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I put a Date Column in my subform after it has already been created?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Unremovable horizontal scroll bar on subform 1
Access Daily Entry with multiple entries per field 0
Using an append query in a subform 1
How to always get the top level form reference, when calling from any subform/subform... 0
Subform 7
Pause Subform 1
data entry in subform before mainform causes huge hassle, HELP! 2

Back
Top