Search results

  1. C

    How to store data from Comboboxes to a table?

    Tried Hi, I deleted the lines you pointed, and test it. It still has a "0" there. No list came out. Do you have time to import my 3 tables to your MDB? Thanks for your prompt reply! Chris
  2. C

    How to store data from Comboboxes to a table?

    another Attach Here is the Row Source for cbosubsystem and cboMajor.
  3. C

    How to store data from Comboboxes to a table?

    Here is my MDB Sorry, I should have said "her/his" . I was hurry in typing and wanted to go to the dinnig room. I almost missed my lunch for these 3 Combos. I was crazy in clicking here and there, they still do not behave the way they should do. When I set the BoundColumn to 1. they work...
  4. C

    How to store data from Comboboxes to a table?

    Thanks to Mile-O-Phile for her reply. I read the BoundColumn Property from Access Help. It should store the 2nd column if I set it to 2 . Then I set this property value to 2 for all 3 Combos. What happened was, the 2nd and the 3rd Combo no longer show the list! no matter how hard I click the...
  5. C

    How to store data from Comboboxes to a table?

    Hi, The Problem I stated in my reply post ( 03-02-2003 12:57 PM by croby) has been solved. I found my mis-operation. Now I can store the data values from cboSystem, cboSudsytem and cboMajor to the table called IC. The stored values are ID numbers -- column(0). Can I store the Names --...
  6. C

    How to set a list of values for a Combo box based on a selected value in another Co

    Dynamic Comboboxes I clicked the link filteredcomboboxes.zip (from ghudson, I downloaded), which leads me to Lancer’s message page. Here I found a Tutorial Dynamic Comboboxes . I don’t know who wrote this tutorial.(there are many names on that page.) It is pretty good. I followed the samples...
  7. C

    dynamic comboboxes

    The tutorial - Dynamic Comboxes ? Hi, I clicked the link filteredcomboboxes.zip (from ghudson), which led me to Lancer’s message page. Here I found a Tutorial --Dynamic Comboboxes . I don’t know who wrote this tutorial.(there are many names on that page.) It is pretty good. I followed the...
  8. C

    How to set a list of values for a Combo box based on a selected value in another Co

    Reply to Skwilliams -- combo box issues Your example is very good. I followed your instructions and applied them to my database. As I said in my last post, I have 3 tables. The list values in the second Combo box should be a JOIN results. The first Combo box (cboSystem) works fine. But the 2nd...
  9. C

    How to set a list of values for a Combo box based on a selected value in another Co

    Hi, I’m designing a form by using ACCESS 97. My database includes 3 tables: System, Subsystem and Major. They are linked by their IDs. Suppose the System table has 3 data values: Sys_A, Sys_B, Sys_C. The Subsystem has 10 data values: Sub_1, Sub_2, Sub_3, ……Sub_10. The Major table has 20 data...
Back
Top Bottom