one form to another

[Jade]

can anyone please tell me how to setup a command button that would automatically create a new record based on the form where the button is pressed i.e a button in a employee form that would either create a new medical record, in another form based on the employees i.d number or opens the record if it already exsists. help would be much appreciated