Access Form Incrementing ID

Question

Hi,

I've got a main form in Access where I'm entering most of the information to fill my main data table. Under certain conditions, I've set up a button to become visible on the form, which brings me to a modal form with some additional fields, which go to the same data table. For some reason, when I open the modal form it's adding data to a new entry, rather than the same entry as the main form. Does anyone know why that might be/how to fix it?

Answer 1

I'm doing scientific (archaeological) research, so a lot of data isn't unusual; I'm making about 10-30 measurements for each entry. In this case, I'm recording data about artifacts, and wanted some fields to only appear if they apply to a certain type of artifact. For some of this I made fields visible or invisible based on the selected artifact type, but stone tools in particular require a whole set of extra info, so I put that in the modal form.

Answer 2

Okay, I'll try that -- thanks!

Answer 3

If you use the solution suggested by Tom, be sure to save the current record with:

Me.Dirty = False

before opening the second form in dialogue mode.

Answer 4

Another option would be to have the additional fields on a Tab Control; just put them on a second tab to be displayed when needed.

I'm a bit concerned about your data model though, if you have so many fields that you need two forms to display them all!

Answer 5

You would want to open the modal form to the same record (with same PK value).

A simple way to do that is to use the WhereCondition argument of DoCmd.OpenForm:

docmd.openform "myModalForm", WhereCondition:="CustomerID=" & Me.CustomerID, WindowMode:=acDialog