pop up box

[Amanda]

Good Afternoon!
I Have several forms that I use for changing data in a
table. I use a combo box to pull up the record that I
would like to change. The problem is that when the record
is not found, the form reverts to the first record in the
set. This can be very confusing. I have seen other access
applications that have a pop up box that notifies you that
the search object is not found. Does anyone know how to
do this?

Thanks in Advance,
Amanda

 

[Larry Linson]

With some detail on _how_ you are using the Combo Box to pull up the record,
perhaps someone could help. Are you using code as generated by the Combo Box
Wizard using the third option on the first screen? Are you using something
else? Have you looked at the code that is used behind the Combo Box to
display the selected record? ... that kind of thing...

All the search-and-display techniques that I use can detect that no such
record was found, and take appropriate action -- often including a MsgBox,
or similar form, to inform the user. If it is useful to add the record, then
I'd open a form in data entry mode.

Larry Linson
Microsoft Access MVP