Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    I may need consulling.

    Friends i have a form that is associated with a table that has 177 cases. A combo box on this form is used to select the company name. The next time when I open the form on, my data seems to have disappeared. When it happens the form shows 1 case out of 1, and the case is empty. I first thought all was lost, but I go into design view and reassociate the form with the table. It all comes back. Can anyone suggest why this is happening. I intend to distribute the database, but before i do so i would like to correct this problem. This is frustrating to no end. Please convince me that I am not losing my marbles. I may need consulling.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: I may need consulling.

    I don't know about your marbles, but I think we can help you out. Just lie down on the couch and tell us all about it. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Is the form actually bound to the data? In other words, does the form have its recordsource set to the name of a table or query or to a select statement? If so, have you tested that recordsource to make sure it will return records in its current version? Is the combobox unbound (I hope), and does it have items in it when you experience the problem with the form?

    One of the things I generally do is to load my forms with no available records and force the user to select from a combobox. I do that by setting the form's recordsource to a select statement that never returns any records. When they make a choice from the combobox, I set the recordsource of the form to a new select statement that returns only the record associated with the selected value. Did you possibly try something like this and forget about it?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    still clueless

    i may be losing it. The form is bound to the data a table called t_grille . The combo box is is based on a query of the table t_grille. But when i open the form the second time, it says the form is based on the table t_grille. Yet it says there in only only one case. and The combo box has nothing in it. I then go to the properties settings of the form and the data says is based on the table t_grille. I then select click on the selection and reselect the table t_grille. Afterwards all 177 records are there, and the combo box has all 177 names. still clueless

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: still clueless

    Post the SQL for your combobox and the Form_Open event for the form. It sounds like your form might be holding onto a saved value in the combobox. Make sure the form is closing with no saves to the design when you close it and if this is Access 2000, make sure the form's Allow Design Changes property is set to Design View Only.
    Charlotte

  5. #5
    Pat Hartman
    Guest

    Re: I may need consulling.

    Is there a filter set anywhere?

  6. #6
    TracyF
    Guest

    Re: I may need consulling.

    Is the Form's Data Entry property set to yes?

Posting Permissions

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