Linked field

[Guest]

I have a form with a lookup field where when I choose it I want another field
to automatically fill in. I have created the following on update in the
lookup feild but it will not work. C_Part_1_code is the field looking for
the automatic fill in.
C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=ME!CODE")
Can someone please explain what I have done wrong. Thanks

 

[Duane Hookom]

If Division is numeric then try something like:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=" & ME!CODE)
If Divsion is text, try:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=""" & ME!CODE
& """")

 

[Guest]

Thanks Duane its not working; does it matter that [block] is a query? I
queried some information to combine it and want to look up the information in
the query, it works for the lookup portion but maybe I shouldn't be doing
this?

If Division is numeric then try something like:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=" & ME!CODE)
If Divsion is text, try:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=""" & ME!CODE
& """")

--
Duane Hookom
MS Access MVP

I have a form with a lookup field where when I choose it I want another
field
to automatically fill in. I have created the following on update in the
lookup feild but it will not work. C_Part_1_code is the field looking for
the automatic fill in.
C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=ME!CODE")
Can someone please explain what I have done wrong. Thanks

 

[Duane Hookom]

"its not working" isn't very descriptive. It shouldn't make any difference
if BLOCK is a table or query as long as the query isn't a parameter query.

We can't help much since we don't know anything about your tables, fields,
queries, data types, records,...

--
Duane Hookom
MS Access MVP

Thanks Duane its not working; does it matter that [block] is a query? I
queried some information to combine it and want to look up the information
in
the query, it works for the lookup portion but maybe I shouldn't be doing
this?

If Division is numeric then try something like:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=" &
ME!CODE)
If Divsion is text, try:
Me.C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=""" &
ME!CODE
& """")

--
Duane Hookom
MS Access MVP

I have a form with a lookup field where when I choose it I want another
field
to automatically fill in. I have created the following on update in
the
lookup feild but it will not work. C_Part_1_code is the field looking
for
the automatic fill in.
C_PART_1_CODE = DLookup("DIVISION", "[BLOCK]", "DIVISION=ME!CODE")
Can someone please explain what I have done wrong. Thanks