Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Location
    Waikato, New Zealand
    Posts
    28

    Unanswered: Date not working in form

    What am I not doing right?
    I have created several tables and one of these is a table mainly to allow dates to be entered. When I try to create a form to enter data my problems begin. Every other table accepts data. The date table only accepts data if it is the only table in a form. As soon as I put another field from a different table on the form the date will no longer be recorded even though the date picker is showing? I suspect it is to do with the relationships but cant see where I have gone wrong. Any clues out there?

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    A form can only have one RecordSource. That RecordSource can be a query with more than one table joined in it. Maybe your issue is described here: Microsoft Access tips: Why is my query read-only?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •