Search for a record to input survey form

[GraemeG]

Hello,

I have 10806 records (Addresses loaded into the database).
This includes:
UPRN - Unique Property Reference Number
Hs No - House Number
Address 1
Address 2
Address 3
Postcode

These address are linked to another programme via macro import and are updated by a button (Another question to come is can it be run automtically)

However when a form is selected.
The surveyor then Clicks a button to Search for a property via the UPRN.
When the button is clicked a 'Find What box comes up and the surveyor must make sure it is looking in UPRN field in order for it to find it.
Then they have to cancel to see if record is found in background.

i was wondering whether there is another easier search option.
Simply a box appears they type the uprn in and it finds the address telling you whether it is found then they click OK to proceed.

I hope I have been clear.

Any help much appreciated.

 

[DCrake]

You should be able to use and InputBox()

Dim Message, Title, Default, MyValue
Message = "Enter a value between 1 and 3"    ' Set prompt.
Title = "InputBox Demo"    ' Set title.
Default = "1"    ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)

' Use Helpfile and context. The Help button is added automatically.
MyValue = InputBox(Message, Title, , , , "DEMO.HLP", 10)

' Display dialog box at position 100, 100.
MyValue = InputBox(Message, Title, Default, 100, 100)

 

[GraemeG]

Thanks for reply.
I am new to all this and dont seem to understand.

Do I insert a text box with a code builder and insert the above?