Looking up data

  • Thread starter Thread starter Alex Hammerstein
  • Start date Start date
A

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
 
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
 
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.
 
Back
Top