Search record issue

[GraemeG]

Hello,

please refer to attached pic.

I have survey forms which is pre-popluated with certain fields.
Ie. The address and tenant detail fields already contain information for 10000+ records.

The surveyor searches for a property by the UPRN field and then fills in the rest of the fields for that record.

However at the minute the process is a bit too messy.
For instance the surveyor will click the search UPRN button, type in the uprn and click find what.
Although this search doesnt always look in the right field and then doesnt tell the surveyor if an address has been found and then can cancel the search.

I am wondering if anyone can help me.
I am after a simple click button, a box pops up they dont need to mess with any settings, just type the UPRN number in and click search. Then it tells the surveyor whether the record has been found or not.

Can anyone assist? much appreciated

 

[GraemeG]

Infact.
Is there a way of setting up a form where they search for a record, then select the survey form they want and it opens with that record select for them to fill in the details?

 

[tonez90]

To see if a record exists or not can be quickly don eusing the dcount function

if dcount(recordname,tablename,where condition) <> ) then it exists else it doesnt.
if it exists then populate the form using me.recordsource else popup a message saying nothing found
I use this in my search function:
strSql = "[" & Me!cmbo_Fields.value & "] LIKE '" & Me!txtpattern & "'"
If DLookup("[IDNumber]", Me.RecordSource, strSql) > 0 Then
....etc
Me!cmbo_Field.value is actually the fields in the table which are searchable (determined via code each time), IDNumber is a field in the table, Me.recordsource is the table for the form (as I use this function on multiple forms) anyway I hope this helps.