Warning! Access initiate present!!! Please handle with care. :)

I am creating a table which will eventually display as a form. What I want is for the value of some of the fields to be replicated in others automatically. e.g. If I was using Excel I would just tell a cell to = another one. How do I do that in Access?

Thanks in advance.

Forget Excel! Access works in a very diferent way. In Excel your data storage and your data display are basically the same. In Access, data is stored in one or more tables and displayed in forms or reports, so the methods of working are not the same.

What you need, I think, is to understand queries. It is always best to base your form on a query rather than a table because of the flexibility this allows you. Even if you wanted exactly the same fields on your form as are in the table, using a query will allow you to make changes later. Anything that you can do with your data in a table you can do in a query, plus a whole lot more.

Right so next we have to deal with replicating data. Don't do it. Anything that is simply a copy of data held elsewhere and anything that can be calculated or derived from data held elsewhere should be created 'on the fly' using a query. Alternatively, if all you want is to display the same field in two different places, all you do is make the same field the record source for two text boxes on the form.

If this doesn't seem to make much sense, give us more details of what you want to do, and we'll help you out.

Thanks, mate! This makes a lot of sense.