Data sheet not adding new record

[pat15]

normally, when you type something into a datasheet
it would add a new record.

how ever I am using a pop-up dialog to input a value in to the datasheet.

then the datasheet does not add a new record.


how do i make this happen?

I don't have any fields to dirty. all the fields are locked so user can only use the pop-up dialog.

 

[pat15]

Me.Requery



now....... I have to look for a way to store and load current postion

 

[pat15]

For those who might search the forum looking for an answer

  Me!ItemId = GetItem
  Dim OldId As Long
  OldId = Me!Id
  Me.Requery
  Me.Recordset.FindFirst "[Id] = " & str(OldId)

I do not like messy codes. so if that code can be simplized please help.