Excel/Access update records

Good morning,

Im a little confused as to how to get this to work.
I have a userform that when filled in sends the data to MS Access to store as a database. (i have to use it this way as users dont have use of Access I can only use it to store data)

However, there is a time where the record thats been added needs to be changed.

How do I code a button to locate the record to be able to update? If the users are adding a unique reference everytime.

Ideally, I'd want the empty boxes to populate with what the record states so this can be changed..
(ps. Excel & Access 2007)

Thanks in advance.

What is Search and how does it get a value?

Also is the field [Claim Number] numeric or text?

Is the field name 'Claim_Number' or 'Claim Number'?

PS If you want to return other fields eg Recommendations you'll need to include them in the query.

The query isn't quite right.

For a start if the field is numeric then you don't need the single quotes around the search term.

Also what is the field name?

In your query you call it 'Claim Number' and 'Claim_Number', it can't be both unless you are actually referring to 2 different fields.

Finally the query only returns one field, the claim number, but you refer to 2 other fields, ongoing and recommendations.

If you want the values from those fields you need to include them in the field list.

Why did you remove the WHERE?

If the field name is 'Claim Number' you'll need to use [Claim Number] in the query.

One way of getting the syntax for the query would be to open the database, create an example query in the Query By Example view and then goto SQL view.