It still brings up an error, i think because it is a composite key, it requires something to be in both the fields
Hi Goldstar. It wasn't until I read your other recent thread at
http://www.thescripts.com/forum/thread780473.html that I realised you are not using standard methods of database design, and in particular you are trying to place multiple values into individual controls, for reasons that I can only guess at.
If there is a compound key involved you should as far as possible have the field values automated by an appropriate method (such as linking parent-child fields between a subform and a main form). It is
never appropriate to have users enter compound key values themselves in a single text box.
There are useful examples of typical form/subform designs in the Northwind database that comes with Access. You will not find any that require users to enter compound key values in single textbox controls.
This is a different matter from
displaying a compound key value (for example a year followed by a job number, 2008-105 say) where you can have a single text box displaying the value without expecting users to enter it that way.
-Stewart