Setting Primary Key Of New Row Being Inserted

Not sure if this is the right place for this post or not, but I'll give it a try...

If I am inserting a record into a table that uses a Primary Key, but not an Identity column, how do I insert the new primary key value? I started out with SQL just letting the Identity column increment itself for primary keys, but I cannot do that for this particular situation.

If 'AddressID' is the primary key in the 'Address' table, could I do something like this:

INSERT INTO Address (AddressID, Field1, Field2, ...)
VALUES (**max value of primary key in Address table, plus 1**, 'field1data', 'field2data', ...);

If that works, how would I make this part of the insert query:
**max value of primary key in Address table, plus 1** ?

I hope this question is clear and makes sense. If it's not, please let me know.