Recent content by accessuser67

  1. A

    cascade combo box

    Could I use a text field as my primary key in Access 2010? Or will this cause problems for combo boxes and other controls in a form? Regards.
  2. A

    cascade combo box

    If I were to change the primary key to storeId I would then have to change and look up in the store table for the correct StorId whenever I'm adding data to the category aisle table. I was trying to make entering data on all tables simple. But yet I still the CategoryCombo box gets stuck on...
  3. A

    cascade combo box

    Thanks for all the suggestions on this matter. Regards to everyone that helped out, I think I can proceed from here.
  4. A

    cascade combo box

    Before I had the primary key set to the storeId in the stores table but the combo box CategoryCombo was showing blank. But did you see how the CategoryCombo box sticks on the first record? Your assistance is greatly appreciated. Regards.
  5. A

    cascade combo box

    I have the second combo box CategoryCombo that sticks only on the first record on the drop down list. It doesnt allow me to select another record from the drop down. I think it is a Microsoft Access glitch. Your suggestions will be greatly appreciated. Regards.
  6. A

    cascade combo box

    I think maybe there is a glitch in the Microsoft Access 2010 program. I tried just about every feature of the combo box CategoryCombo and still it sticks on the first record of the drop down box. Any suggestions would be greatly appreciated. Regards.
  7. A

    Combo Box malfunction

    GroceryF is the form I'm referring to. Thanks. Regards.
  8. A

    cascade combo box

    Yes I have the after update me.categorycombo.requery. But now the categorycombo box just sticks on the first record in the drop down list and it would not move to another selection in the drop down list. This seems like a microsoft access glitch. Please help. Regards.
  9. A

    cascade combo box

    SELECT CategoryAisle.Store, CategoryAisle.Category, CategoryAisle.Aisle FROM CategoryAisle WHERE (((CategoryAisle.Store)=[Forms]![GroceryF]![StoreCombo])) ORDER BY CategoryAisle.Category; That is the code from the second combo box. The first combo box code is SELECT [Stores].[StoreID]...
  10. A

    Combo Box malfunction

    My database is attached: Looking forward to your suggestions. Regards.
  11. A

    cascade combo box

    Somehow I got the combo boxes to work but now the second combo box is malfunctioning. Not sure if I'm suppose to write more code. I have a form with two combo box cascading as it is known. The second combo box uses selection from the first combo box to filter the drop down list in the second...
  12. A

    Combo Box malfunction

    Currently, I have a form that has two combo box and the second combo box relies on the first to filter the second combo box. It was working fine but now the second combo box does not allow me to select from the drop down list. It resorts to the first record each time and when I try to change...
  13. A

    cascade combo box

    I have 2 combo box also and but when I put the second combo box to filter based on the first combo box I get a blank second combo box, no records to select. Do I have to use the request and got focus code to make it work. It's just a simple 2 combo box where after I select record from the...
  14. A

    Combo box

    Want user to be able to select none from the drop down list when they do not see a selection they want. How do I include none in the combo box? Regards, Ekmoorhead
  15. A

    Display combo box value in a text box

    Just the code I was looking for for months. Thanks a bunch. It worked for me. Regards, Ekmoorhead
See more
Back
Top Bottom