[Daisie]

When trying to select a choice from a drop-down in a new form; the info line shows this..
"Cannot add record(s); primary key for table 'dbo_Asset_Type' not in recordset.".. almost like it is expecting the record to already be there?

[etaf]

moved to business applications forum

[OBP]

What is the Control Source of the Drop Down list.

[Daisie]

Asset_Type_dbo_Asset_Type is the control source and SELECT dbo_Asset_Type.Asset_Type FROM dbo_Asset_Type; is the row source

[OBP]

It is a bit difficult from that description to tell if the drop down row source is coming from a different table to the Control source.

[Daisie]

Ok, tell me how to get you a copy of the property sheet.. I have a copy of it in Excel.

[OBP]

That will do, you can post it on here as an attachment using the "Go Advanced" and Manage Attachment buttons.
A copy of the table relationships would be helpful as well.

[Daisie]

At this point I don't have any relationships.. could that be the problem?

[OBP]

It shouldn't be the relationships, can you save the Excel sheet in Excel 2003 and re-post it please?

[Daisie]

Here you go.

[Daisie]

Had to zip it.

[OBP]

What field type is the Asset_Type_dbo_Asset_Type in it's table?
What field type is the Asset_Type in the dbo_Asset_Type table?

[Daisie]

Asset_Type is an integer that feeds to the Asset_Inventory table (feeding the ID) and Asset_Type has the ID (int) and Type (nchar) columns.

[Daisie]

At least that's what I want it to do.. I want the drop-down to show the type but feed the id to the other table.

[OBP]

That is what should happen, but only the ID should be stored. The first column in the Drop down should be the ID and set to 0cm width to hide it and should be the Bound column. The second column should then display the Asset_Type.
If this was Access 2003 I could take a look for you, but I can't work with Access 2007/10.