Thanks for your reply,
i am still having a spot of bother wiht the code. below i have pasted the code i am using can you tell me whta ive done wrong.
DoCmd.OpenForm "invoice", acNormal, , "[ID] = forms!f_outstanding invoices!ID", acFormEdit, acWindowNormal
thanks