#Error in subform foreign key

N

NickX

Hi all,
I am getting "#Error" in my foreign key id field for two subforms, but
not the third. As far as I can tell each is setup in their respective
tables similarly. I have tried deleting, changing thpe data type,
I've even re-created the whole database (re-created suspect tables and
imported everything else). Whenever I try to add values in any field
on the subform I get "The value you entered isn't valid for this
field..."

I'm at a loss.

Thanks in advance,
Nick
 
N

Nick X

Update:
I created a new main form based on the same table and added in the existing
sub-form. It works properly. Wher should I look in the original form to
find what is causing the problem?
 
I

i_takeuti

NickX said:
Hi all,
I am getting "#Error" in my foreign key id field for two subforms, but
not the third. As far as I can tell each is setup in their respective
tables similarly. I have tried deleting, changing thpe data type,
I've even re-created the whole database (re-created suspect tables and
imported everything else). Whenever I try to add values in any field
on the subform I get "The value you entered isn't valid for this
field..."

I'm at a loss.

Thanks in advance,
Nick
Click to expand...
 
A

Allen Browne

Well, you already have a workaround, Nick, so it's probably best to go with
the new form.

The old problem could have been caused by Name AutoCorrect:
http://allenbrowne.com/bug-03.html
or a badly named text box (its Name was the same as another field),
or an invalid Format on the text box, etc.
 
N

Nick X

Thanks for your response Allen,
I think it was a combination of name auto-correct and a bad text box. I
turned off name auto-correct, deleted the text box on the main form and
dropped a new text box in its place. It seems to work now.

Again thanks,
Nick
 
N

Nick X

Allen,
Now that problem is fixed, I am having another issue that I believe is
related. My sub-form is not displaying the records when I move the focus of
the main form to another record and then back (or close and re-open) the 2
other sub-forms are showing their records?!?
Any help would be appreciated,
Nick
 
A

Allen Browne

Sounds like the Link Master Fields and Link Child Fields properties are not
set correctly.

Or possibly a Filter is applied.
 
N

Nick X

Turns out the sub-form was corrupt also. I created a new sub-form and now
everything SEEMS fine.
Thank you for your help,
Nick
 
Top