Where I'm up to, so far:

2 forms 

            - form 1 : Customer Details, Name, Address etc

            - form 2 : Drop down - which displaying customer name

                            and a Rich text format box

What's happening at the moment is:

Access form 2

- select Customer by name (drop down)

- enter text into the Rich Text box

- Submit

this creates a new record every time:

What I'd like to happen is:

Access form 2

- select Customer by Name (drop down)

- Enter new details into the rich text box or Update previous details in the Rich text box.

- eliminating duplicate submissions

would love to know how i can go about doing this?

Kind regards

Luke