Results 1 to 3 of 3
  1. #1
    lllanos is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2016
    Posts
    7

    Report with dropdown list, not working correctly in navigation form

    I have a report that I created a dropdown list using a form and query to create. When I use the form to open the report, the dropdown works just fine. But when I put the form onto a navigation form I still get the dropdown list, but then I get a message box requiring me to enter the information again. What do I need to do to correct this?

    Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,522
    Why is the form in another form?
    the master form should open your report form by itself.
    then the queries can read the standalone form.

  3. #3
    lllanos is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Nov 2016
    Posts
    7
    I have the database set up so the users only have access to their own navigation form. This way they only see the forms/reports that they need. It helps keep users from making changes to other forms and helps keep the users from getting confused with too many options.

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

Similar Threads

  1. Widening dropdown list columns on form
    By George in forum Access
    Replies: 1
    Last Post: 08-14-2015, 04:12 AM
  2. Update query w/form not working correctly!
    By breakingme10 in forum Queries
    Replies: 3
    Last Post: 11-05-2014, 02:27 PM
  3. Calculated field on a form not working correctly
    By danielrogers1 in forum Access
    Replies: 5
    Last Post: 07-28-2014, 01:24 PM
  4. Replies: 5
    Last Post: 03-17-2011, 06:21 AM
  5. Split Form not working correctly
    By Brian62 in forum Access
    Replies: 29
    Last Post: 02-16-2010, 05:43 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