MS Access Help

Evigilant

I've created an unbound field in my form, it's composed of the values from drop down boxes, and I want this field to be my primary key.

I seem to have had a brain fart, as I can't make the primary key field = a value from another box.

Here's the very brief layout of my table and form, removed the actual names because of security reasons:

My table layout:
Pkey = Primary key: Text
Offices: Lookup menu
Types: Lookup Menu
Fiscal Year: Lookup Menu
#: (autonumber)


This is what my form looks like so far:
Drop down menu: Offices
Drop menu: Types
Drop Menu: Fiscal Year
Drop Menu: Functional Area
Drop Menu: # (this is auto generated)
Unbound Field: Actual
Bound Field: Primary Key

And the code for the unbound field, "Actual"
Name:
Actual

Control Source: =Format([Offices]) & Format([Types]) & Format([Fiscal Year]) & Format([Functional Area]) & Format([#])

I want the value created by "Actual" to create the "Primary Key".