code required for an update event in a form

[Surinder Kumar Arora ITS GM EAST MTNL Delhi]

Dear Sir,
I want code in a form for update event for a field named telephone having
eight character number property to search for all records telephone field
and return no action if no record is having that value
and if any other record is having that value it should go to that
record(latest record if more than one records are having that value)
regards

 

[Michel Walsh]

Hi,


Use the combo box wizard and make it generates a combo box to navigate
to a record with the value actually in the combo box. The wizard generates
code to find the first match. If the order of the recordset define your
first-to-last sequence, change its VBA code from a FindFirst to FindLast.



Hoping it may help,
Vanderghast, Access MVP