Sorting a datasheet form

[dandot]

I have a datasheet form for the following table in sql server:

CREATE Table dbo.RiskType(
ID INT IDENTITY NOT NULL,
Risk_Type varchar (50) NULL,
Sort_Order int Null)

ALTER TABLE [dbo].[RiskType]
ADD CONSTRAINT XPK_RiskType PRIMARY KEY CLUSTERED
([ID] ASC)


I would like the form to be sorted by Sort_order when presented to the user for data entry.

In order to do this I have set the Record Source = "SELECT RiskType.Sort_Order, RiskType.Risk_Type
FROM RiskType
ORDER BY RiskType.Sort_Order;"

However I find that when I do this, I cannot add any new entries to the form. I can only modify what already exists in the form.

Why is this happening?

 

[ProgramError]

take a look at the data properties of the form( allow additions and data entry.)

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[dandot]

The properties were set.

I fixed this on the sql side by changing the table to the following:

CREATE Table dbo.RiskCode(
RiskCodeID INT IDENTITY NOT NULL,
Risk_Type int NOT NULL,
Risk_Code varchar(25) NOT Null,
Sort_Order int NULL)

ALTER TABLE [dbo].[RiskCode]
ADD CONSTRAINT XPK_RiskCode PRIMARY KEY CLUSTERED
([RiskCodeID])

CREATE INDEX RiskCodeIndex
ON dbo.RiskCode ([Sort_Order] ASC, Risk_Code ASC)