Form not entering info into table correctly

[clinton]

I've set up a form using the Form Wizard incorporating 3 tables. Table A & B feature as combo boxes, and I have a subform for Table C. The data is correctly going into Tables A and C, but not from the combo box for Table B. The Table B combo box is a list of courses, and what I want it to do is to place the course code (the unique identifier) into Table B when you choose from the combo box, but everytime it just puts "0" instead of the correct course number. Can anyone help? Should I perhaps create a query and base the form on that?

Clinton

 

[Fizzio]

If you are basing your form on more than 1 table, it will cause you fewer headaches to base the form on a query as it will allow a little more flexibility in adding info to the form if you need it.
Even using this, it may not solve your combobox problem. On the form, make sure that the control source is the field in table B that you want to store the info and the bound column equal to the value you want stored.

Make sure that your table structure is robust. In table B, you should have a field linked to the table where your course list is eg, CourseID with the same data type and linked by a 1 to many (Courselist to B) relationship.

HTH but post back if you're stuck.

 

[Baldrick]

Hi Clinton

Check the Data tab of your combobox properties. Make sure the Default Value does not have a "0" in it.

Also, be sure the Bound Column property is set to the correct column.