record selector

[Guest]

I have a form with the first field beiing an ID of the record (indexed no
duplicate). When the user open the form he is on the first record what I want
is avoiding the user change that KEY but when the value is change see if
record exist for that value and select the record associated with this value
or create a new one in a new recordset

Thanks


FRED

 

[Van T. Dinh]

You may want to create an *unbound* "Search" TextBox so that the user can
type in the ID number he/she wants and use the TextBox_AfterUpdate to select
the existing Record or move to the NewRecord for data entry by the user.

There are a few more things you can do but let's avoid complications in the
mean time.