Form/Subform “value isn't validâ€


Y

yator

I have a Form with 2 Continuous subforms as follows:

Main Form: frm_doc_con
Record Source: tbl_manual
Fields:
Section: Text
ChapterNo: Text
Chapter: Text
Primary Key: ManNo (AutoNumber-Long Integer) (not shown on form)

SubForm 1: frm_sub_documents
Record Source: tbl_documents
Default View: Continuous
Fields:
DocNo: Text
Title: Text
EffectiveDate: Short Date
Primary Key: D# (AutoNumber-Long Integer) (not shown on form)
FK: ManNo (Long Integer)
Link Child: ManNo
Link Master: ManNo

SubForm 2: frm_sub_rev
Record Source: tbl_rev
Default View: Continuous
Fields:
Revise_Date: Short Date
Review_Date: Short Date
Primary Key: RevNo (AutoNumber-Long Integer) (not shown on form)
FK: D# (Long Integer)
Link Child: D#
Link Master: FrmD#Relay – text box on Main Form Control Source:
=[frm_sub_documents].[Form]![D#]

SubForm 1 works fine for data entry/edit etc. Sub Form 2 gives the following
problems:
1. When I try to enter a new record in any date field I get the message “The
value you entered isn't valid for this fieldâ€. After hitting the OK button, I
can proceed to enter data as normal.
2. If I start a new record entry in a Text field I don’t get the error
message. Instead, after typing the first character, the cursor backspaces to
cover that character so that if I keep typing the first character is
overwritten. After this, I can type in any of the new record fields including
dates without any problem.
3. If I have multiple records in SubForm 2, when I go to enter a new record,
the line of the new record jumps to the top so that I can not see the
previous records.

There are no Default Values, Required Fields or any ZeroLength Fields
allowed in any underlying tables. All data types seem to agree. All Text
Boxes have unique names. There are no Modules with any of the forms.
 
Ad

Advertisements

Y

yator

please disrefard this post. I will repost to the "Forms" section. Sorry for
any inconvenience.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top