Differents Fields

  • Thread starter Thread starter Alimbilo
  • Start date Start date
A

Alimbilo

Hello,
How can I import data from a field in Table A and duplicate it in a
different field in Table B. Please Help!!!
 
Is this another version of the same question you asked earlier, to which
myself and two other posters all told you that you shouldn't be doing
that? Or is this something else?

If it is the same question, perhaps you could enlighten us as to why you
are determined to do it against advice to the contrary.
 
It's the same. But my question is why can't I use:

Field1 =[Table B]![Field2]

where Field1 is on Table A.


Everytime I am trying that I am getting a "#Name?"
 
I'm guessing that you are trying to use this as the control source of
an unbound control on a form, which won't work. You would need to
use Dlookup, or something similar. If you are trying to sum the values
in two fields in your first table, your best option might be to create a
query with a calculated field, then use the query as the record source of
your form (as was mentioned in the other thread)
--
_________

Sean Bailey


Alimbilo said:
It's the same. But my question is why can't I use:

Field1 =[Table B]![Field2]

where Field1 is on Table A.


Everytime I am trying that I am getting a "#Name?"




Beetle said:
Is this another version of the same question you asked earlier, to which
myself and two other posters all told you that you shouldn't be doing
that? Or is this something else?

If it is the same question, perhaps you could enlighten us as to why you
are determined to do it against advice to the contrary.
 
Back
Top