A
abefuzzleduser2
We use Access 2000 and linked SQL server 2000. I started getting this
error on subform data entry "The value you entered isn't valid for this
field". This error occurs immediately when I type in ANY of the subform
fields (first character).
The SAME subform works on a different form and updates FK just fine.
The main form and subform both an identity column as PKs. Both
subforms use tables directly. The subform that works, main form query
gets tblPO on the outer join. The one that does not work uses tblPO
the non-outer side for main form. Subforms are setup the same both use
POID as primary and subform keys. The Subform has Item (textbox),
Description (textbox), Qty (textbox), Code (static DROPdown list) and
resolved (checkbox). Nothing has changed in past year for MDB? I also
deleted the dropdown box and checkbox with no chage.
I built a new subform to use using all text boxes since I found some
users had problems with dropdown lists. But I got the same error.
CREATE TABLE [dbo].[tblPODiscrepancyItems] (
PK [PODiscID] [int] IDENTITY (1, 1) NOT NULL ,
FK [POID] [int] NULL ,
[Item] [nvarchar] (50) NULL ,
[Description] [nvarchar] (50) NULL,
[Qty] [int] NULL ,
error on subform data entry "The value you entered isn't valid for this
field". This error occurs immediately when I type in ANY of the subform
fields (first character).
The SAME subform works on a different form and updates FK just fine.
The main form and subform both an identity column as PKs. Both
subforms use tables directly. The subform that works, main form query
gets tblPO on the outer join. The one that does not work uses tblPO
the non-outer side for main form. Subforms are setup the same both use
POID as primary and subform keys. The Subform has Item (textbox),
Description (textbox), Qty (textbox), Code (static DROPdown list) and
resolved (checkbox). Nothing has changed in past year for MDB? I also
deleted the dropdown box and checkbox with no chage.
I built a new subform to use using all text boxes since I found some
users had problems with dropdown lists. But I got the same error.
CREATE TABLE [dbo].[tblPODiscrepancyItems] (
PK [PODiscID] [int] IDENTITY (1, 1) NOT NULL ,
FK [POID] [int] NULL ,
[Item] [nvarchar] (50) NULL ,
[Description] [nvarchar] (50) NULL,
[Qty] [int] NULL ,
Code:
[nvarchar] (50) NULL ,
[Resolved] [bit] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblPurchaseOrder] (
PK [POID] [int] IDENTITY (1, 1) NOT NULL ,
[Date] [datetime] NULL ,
[DocNumber] [nvarchar] (20) NULL ,
....
I dont use any validation , defaults etc. I was able to add add data
directly to
Items table.