Replicate Column info

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I am working on a project that requires me to populate a column with the
exact info from another column. Is there a way that I can pull in the same
value as another column in a table?
 
First, make a backup of your data.

If your field already exists, do an Update query. Choose the new field and
then on the Update to line, put the field name which has the data you want to
add.

If this is something you need to do when the record is getting added, put
the following code on the After Update event of your first field.
Me.SecondFieldName = Me.FirstFieldName

Hope this helps,
Jackie
 
You must log in or register to reply here.

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

Similar Threads

Replicate column info 1
Excel Help to copy information from one row at a time to another sheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Create New Table/Column 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Info on Report 3
Limiting data pulled from another table into a lookup column? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top