Buttons on form not showing complete data

Posted on 2012-08-29
Last Modified: 2012-08-30
Hi Wise Ones...
I've attached a database and I'm having the following problems with it...
The user wants the following ((View all locations painted) to have a list of locations down the left and then for the users to just click on a location/month (it'll change colour when done - thanks for the help on that one :-) ) so that they have an overview of the entire painting occurrence.
Then I have set up a form (View History) which should show the individual history for each location - but it's not. E.g. if you click on View History for Admissions it should show July and January painted (or even ticked) but it's not...what am I missing?
Question by:agwalsh
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Do you have one question here or two?
    (This site allows only one distinct question per post)
    I can't see how the "Color" question is related to the "View History" question...?

    When posting a sample database, pleas post the exact steps to replicate the issue.

    Finally I am not sure what your are needing here:
     <so that they have an overview of the entire painting occurrence. >
    so also try to post some type of graphic, clearly indicating the exact results you are looking for.



    Author Comment

    My apologies...Let me tackle the question I want answered first..

    I want to sort out the View History one - I can't figure out why when I click on the View history button it doesn't actually give the history i.e. boxes ticked. That's the main question I want help with. I can sort out the colour thing myself (thanks to help here).

    Click on button - View all locations painted.
    Scroll to right
    Click on View history button
    (I've used Admissions as the sample data)
    That brings the user to the individual form OK but doesn't show that there were two boxes ticked i.e. May and March...
    That's what I'm trying to figure out...

    LVL 29

    Accepted Solution

    Sorry but I couldn't figure out why your continuous form only showed a single record so I just recreated it for you.  Chances are that the other one was corrupted in some way.

    Author Comment

    @irog sinta - this worked...thank you. However another question has now arisen from this. when I click on the View History it works fine but my combobox no longer works. It'll work to locate a record if I go straight into View/Edit history of individual locations from the switchboard  but if I go to the View/Edit history of individual locations - via the Show History button it no longer works - any ideas?

    Author Closing Comment

    Did exactly what I wanted - thank you :-)

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now