Populating a control without creating a record

[charlie12345]

I want to populate the ID field with a value the user has entered, without automatically creating a new record in the table.
If I set the control before I open the form (e.g. Forms!frmData.StoneID = Me!StoneID) the form automatically runs Update, and creates a record.
I've tried setting the 'Dirty' property to False, but that didn't help.
Suggestions?

Thanks,
Charlie

 

[RoyVidar]

Well - the form shouldn't run an update only by populating a control, but entering a value in a bound control, would create a new record.

A workaround here, might be to populate an unbound control with your value,

[tt] Forms!frmData!txtTempStoneID.Value = Me!StoneID.Value[/tt]

and then on an appropriate event (for instance the forms before update?), assign this controls value to the control bound to the id field.

[tt]Me!txtStoneID.Value = Me!txtTempStoneID.Value[/tt]

Roy-Vidar