Problems attempting to add new record to table

[Micron]

OK, but doing a move first or last is not a requery. Or am I not following?

Me.RecordsetClone.MoveLast
lngCount = Me.RecordsetClone.RecordCount <<now lngCount is the recordsetclone record count
DoCmd.OpenForm "frmItemDescriptor", , , , , acDialog << a different form opens. If it alters the recordsetcount of the first form, it won't alter the clone of the first form
Me.RecordsetClone.MoveLast <<so if the recordsetclone.recordcount is 20, so is lngCount

Did you remember to step through your code and examine your variables and properties that they might relate to?

[Welshgasman]

I would have thought the requery would be needed to see if a new record had been added?
I would probably requery regardless but stay on current record, as the form was opened generally to add a new record?

However the DCount() should show any difference without needing to requery?

[pbaldy]

Bill is having difficulty posting and asked me to post the following thoughts:

Would you point out to him (Micron) that the two forms involved use the same table as Recordsource, thus the subordinate form might in fact add a new record as part of its multi-purpose functionality.

Somehow I've failed to create the understanding that the main form uses a common form to either display the current details of an already registered item versus adding a new item. In the latter case, the user might or might not actually add a new item but rather investigate some of the images available pertaining to the intended item. Hence, the "main" form needs to know if a Requery is needed when a new record is added. Item records can hold the names of up to six images of the item. See second screenshot.

[Micron]

Thanks for that assistance. This thread is marked as solved, so am I just confusing things by chiming in? Or is there still a problem?
I made a point about using a wildcard in post 9 that may or may not be pertinent but I don't see where it was addressed. Also, in post 29 I'm saying that the recordsetclone is a fixed object in memory. If you add a record to the form recordset the recordsetclone won't be affected whether you move last on it or not. Or am I wrong about that?

I agree with WGM. If there's code for the event where a record is added, then requery the form from there. You may have to bookmark the recordset clone before requerying, so that you can stay on the current record.

Maybe try pm'ing to see if that works if you can't post. If I'm not helping let me know and I can bow out, otherwise I might have to read all from the beginning.
I don't suppose a db copy is available?

[Welshgasman]

My tip for requerying and NOT moving from current record is to requery the recordset NOT the form