Updating field in table

[BartK]

Hello everyone, I need a little help updating a field in a database based upon a person employee number. To me is sounds simple in theory but I have not messed around much with the find or go to record in access.

I would like to punch in their employee number, have all their information pulled up and then be able to change some of their information. Can a Macro accomplish this or is it something that will have to be coded in? Many thanks.

 

[MarkK]

Hey Bart, can you be more specific about what you need to know? Finding a record and updating a record, for instance, are very different operations. Do you need help doing both? Also, how much do you already have working? Do you already have a table with data in it, for instance? Do you already have a form that lets you view that data?

 

[BartK]

This is what I have this far, just basic bareboned right now. I am kind of torn to either do a search for an employee and update his information all at the same time, or search for an employee and then update his information. I am thinking that the least amount of steps would be the more beneficial approach.

I have attached my database that I have thus far. The form that you need to be concerned with is the update form and the crew change button.

 

[MarkK]

See if it makes sense to you what's going on here . . .