Auto calculate table entry

[Markie]

Hi

I have a table and I would like it to auto generate a Program code made up from other fields.

I.e.

ProgramType ta
Period 04
Year 2002

ProgramCode would then equal [ProgramType]&"-"&[Period]&"-"&[Year]

Program Code ta-04-2002 or ta-04-02

Can this be done in a table at all?

Concatanation is not the issue, I understnand that and use it elsewhere. I cant get the table field to calculate using the entries in other fields in the same table.

I am trying to code it but falling short.

I have been all over the net to no avail and my manuals fall short.

If you have the time any suggestions would be greatly appreciated.

Cheers

 

[dynamictiger]

If you really want to do this then in the data entry form you could have a hidden text box sourced to the field and when you click the close button update your field to the value you want.

However, in Access you normally do not stored calculated results in a table, rather you calculate as required when needed.