ok what am i missing here ?

[baseborn]

Ok ive been trying to create a working form thats going to allow me to enter movies into my database. i only have 2 tables. Table:Movies is the table that needs to be populated by the use of this form. just 3 fields per record (ID,Title and Category). my 2nd table is Table:Categories and it actually holds the list of categories. just 2 fields per record (ID and Category Name). now as far as my form all i need to do is type in a name for the movie im entering into the db, select what category it fits in from the combo box and click "Add Record" and boom its entered into Table:Movies



1 - Friday The 13th - Horror


Well, the combo boxs works fine i mean it shows all of the categories from Table:Categories but the problem is, when i click "Add Record" it doesnt add what i selected from the combo box, so it will look like this

1 - Friday The 13th -

there has been a few times that i can get it to show a number but its not the correct ID for it and plus i dont want it to show the ID i want the name. so i have to be missing or just over looking something real simple. i have created about 20 different forms even types along with the wizard and everything. i even have a relationship set between the 2 tables. Category Name from Tables:Category to Titles from Table:Movies. any idea folks ?

[RuralGuy]

What column from the ComboBox is the bound column?

[baseborn]

It says that its unbound but

Control Source - blank
Row Source - Categories
Row Source Type - Table/Query
Bound Column -1

[RuralGuy]

Select the correct field in the ControlSource property of the cbo and see what happens.

[baseborn]

This Recordset is not updateable... The combo box shows all the categories but wont let me select. Both Tables have a ID column and both are set as the primary key.

[RuralGuy]

You can change a ForeignKey field with a ComboBox but not a PrimaryKey field.

[ssanfu]

Ok ive been trying to create a working form thats going to allow me to enter movies into my database. i only have 2 tables. Table:Movies is the table that needs to be populated by the use of this form. just 3 fields per record (ID,Title and Category). my 2nd table is Table:Categories and it actually holds the list of categories. just 2 fields per record (ID and Category Name). now as far as my form all i need to do is type in a name for the movie im entering into the db, select what category it fits in from the combo box and click "Add Record" and boom its entered into Table:Movies

This is how I would set up the form: (no spaces in names)

Table:Movies 
-----------------------
MovieID           (Autonumber) PK
Title              Text
CategoryID_FK      Long  FK to table Categories


Table:Categories
-----------------------
CategoryID         (Autonumber) PK
CategoryName        Text


Combo box:   
-----------------------
Name:                cboCategory

Control Source:      CategoryID_FK    
Row Source Type:     Table/Query 
Row Source:          SELECT CategoryID, CategoryName FROM Categories  ORDER BY CategoryName;
Bound Column:        1
Column Count:        2
Column Widths:       0";1"
List Width:          1"
Limit to List:       YES