Populate field from 2 other fields in form and save

[DajTwo]

Access 2003, front-back end format.

I have a form 'location_info' populated from table 'tbl_location'.

The table has an autonumber [loc_#] and a index (multiple) [ccan]

What I require is that everytime a new location is created under a ccan the [loc_name] be populated with:

The recourdsource for the field [loc_name] is "=[loc_city] & "-" & [loc_#]"

It works well on the form, requires no input from the user and displayed correctly however it is not saved in the table. I think my record source is wrong

Any help is appreciated.




If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[DajTwo]

Should have been clearer

The fields are located in a subform populated by a query. All other fields on the subform can be populated by the user and the data is saved in the appropriate table

If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[DajTwo]

Found the solution..

AfterUpdate event of loc_city

Me.[loc_name] =[loc_city] & "-" & [loc_#]"

Loc_name field bound to loc_name in query..

Seems to work..

Looks soo simple but when you dont know, you dont know.

Rewarding to figure it out sometimes.

If I did not say it before, I really appreciate the time and expertise of the users on this forum.

 

[PHV]

Anyway, why storing calculated/derived values in a table ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886