V
VERY strange Append Query problem!
Hi,
Ever have one of those query problems that seems to make
NO sense at all. Well here's one. I hope someone can
help.
Ok, On my "Main" form I have many subforms. I have
created a number of unbound fields on my Main form that
represent ID Fields from the subforms. For instance, on
my Main for I have a subform called "Contact". On
Contact I have an ID Field called "ContactID".
Ok, so on my Main form, I have an unbound field
called "ContactID" that is set to:
[ContactID]=forms![Main]![Contact].form![ContactID]
Ok, simple enough. Ok, here's where it gets WEIRD. Lets
say I want to use [ContactID] from my Main form in an
APPEND query. Say I want to append Forms![Main]!
[ContactID] to [InterviewClientID] field in my Interview
Table.
When I try to do this, I get an error message. When I
run the append query in select mode to see what it is
returning, it is giving me CHINESE LETTERS instead of my
[ContactID] value. I'm serious - CHINESE LETTERS.
My question is, what the heck is this?!! When I am doing
an append query, why can't access see the value I have
specified when I am pointing at a field on my Main form?
Where the heck do the Chinese Letters come from?
Ok, to make it even more confusing, I have another
unbound field on my Main form that has its value set to a
column on a COMBO box - like this:
=forms![Main]![ComboBox].column(10)
Ok, now if I try to use THAT value in my append query
just like I tried to use [ContactID] before, IT WORKS
JUST FINE! NO CHINESE LETTERS!
What the heck is going on? Does Access somehow like a
number generated by refering to a column on a combo box
that a number generated by referring to a field on a form?
I am baffled and this is making things very difficult for
me.
Anyone have a clue?
Bill
Ever have one of those query problems that seems to make
NO sense at all. Well here's one. I hope someone can
help.
Ok, On my "Main" form I have many subforms. I have
created a number of unbound fields on my Main form that
represent ID Fields from the subforms. For instance, on
my Main for I have a subform called "Contact". On
Contact I have an ID Field called "ContactID".
Ok, so on my Main form, I have an unbound field
called "ContactID" that is set to:
[ContactID]=forms![Main]![Contact].form![ContactID]
Ok, simple enough. Ok, here's where it gets WEIRD. Lets
say I want to use [ContactID] from my Main form in an
APPEND query. Say I want to append Forms![Main]!
[ContactID] to [InterviewClientID] field in my Interview
Table.
When I try to do this, I get an error message. When I
run the append query in select mode to see what it is
returning, it is giving me CHINESE LETTERS instead of my
[ContactID] value. I'm serious - CHINESE LETTERS.
My question is, what the heck is this?!! When I am doing
an append query, why can't access see the value I have
specified when I am pointing at a field on my Main form?
Where the heck do the Chinese Letters come from?
Ok, to make it even more confusing, I have another
unbound field on my Main form that has its value set to a
column on a COMBO box - like this:
=forms![Main]![ComboBox].column(10)
Ok, now if I try to use THAT value in my append query
just like I tried to use [ContactID] before, IT WORKS
JUST FINE! NO CHINESE LETTERS!
What the heck is going on? Does Access somehow like a
number generated by refering to a column on a combo box
that a number generated by referring to a field on a form?
I am baffled and this is making things very difficult for
me.
Anyone have a clue?
Bill