Looking up data

[Alex Hammerstein]

Hi hope someone can help

I have a field [IMO] which a user enters with a numeric value. On exit from
the field I need to search through the same field in the table, and pop up a
message with the record ID number of previous occurrences of the IMO number

Hope that makes sense and is this possible?

Many thanks

Alex

 

[Jeff Boyce]

An alternate approach, and one that doesn't require the user to
know/remember/correctly-enter your [IMO] number is to use a combobox and let
the user select the correct one.

That way, you can help your user NOT make a mistake...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Create a query for the popup like this --
SELECT [ID]
FROM [YourTable]
WHERE [IMO] = [Forms]![YourFormName]![IMO];

Use Lost Focus event of the IMO text box of the form to call the popup.