How to create a form that can edit a record or create a new record

[Dave H]

I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?

 

[CJ_London]

it can be done but depends how your switchboard works.

As a minimum your switchboard will need a listbox or subform which lists the records to be edited (e.g. recordID and AccountName) and then either an 'AddNew' button or your recordsource modified to become a union query to include 'Add New' or similar.


To detail further you need to explain your setup in more detail for example

is your switchboard a separate form or a subform on a main form
is the form you want to open a separate form or a subform on the main form or a subform on another mainform