Results 1 to 4 of 4
  1. #1
    jegunn is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    2

    Entry of multiple date fields in form

    Hi all,

    I am creating a form to input data about events for a marketing team. One of the items to be captured is whether or not the event needs to be tweeted about, and if so, when. This could entail multiple tweets on multiple dates, or just one.

    Rather than clutter up my form with five date controls when only one might need to be used, is there a way to make it such that a user could trigger an additional date field to appear only if needed?



    Right now the relevant section of the form looks like this:

    Click image for larger version. 

Name:	tweet field.png 
Views:	15 
Size:	2.1 KB 
ID:	20202

    Many thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Code can set Visible or Enabled property. However, this won't work nice in Continuous or Datasheet form.

    Enabled property can be dynamically managed with Conditional Formatting.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Another idea............
    One
    event can have 0 or more (many) "tweets".
    Sounds like the "tweets" should have their own table.??
    Then you could have a main form (events) / sub form (tweets) arraignment.

  4. #4
    jegunn is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    2

    Wink

    Quote Originally Posted by ssanfu View Post
    Another idea............
    One
    event can have 0 or more (many) "tweets".
    Sounds like the "tweets" should have their own table.??
    Then you could have a main form (events) / sub form (tweets) arraignment.
    That worked beautifully, ssanfu - thanks very much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple Entry Date Range Search
    By setnaffa in forum Queries
    Replies: 3
    Last Post: 08-12-2014, 10:22 AM
  2. Replies: 6
    Last Post: 09-27-2012, 08:27 AM
  3. Replies: 11
    Last Post: 06-19-2012, 01:08 PM
  4. Replies: 12
    Last Post: 05-07-2012, 12:41 PM
  5. Replies: 2
    Last Post: 11-16-2011, 07:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums