Using a form to Create and Update Information

[MrKowz]

Good afternoon!

I am in the process of learning Access, and I need to know how I can use a form to update previously-entered information.

I have a table, "Client Info", that I populate with a form, "Client Edit". The form populates the fields [SSN] (key),[FirstName],[LastName],[Address],[City],[State],[Zip].

What I need to be able to do is if I plug in an SSN that was previously entered, it automatically goes to that record and populates all of the fields in the form so I can edit the record.

If a form is not the proper method of doing this, please advise otherwise.

 

[Norie]

Why not just filter for the SSN of the record you want to change?

You really shouldn't need to 'plug in' anything, and you certainly shouldn't use code for this sort of thing.

It's standard Access functionality, as long as you are using the table, or updateable query, as the data source for the form.

You can do the filter manually but it wouldn't be difficult to add some sort of search button/combobox to do it.

I'd actually create a continuous form with the SSN field and a few others that help identify a record, eg first and last name.

This list of records could be easily searched and you could add a button to each record that opens another form where you can edit the data.

You would need a little code for that, as you would for the combobox/button idea, but it would only be for adding functionality to the buttons etc.

It wouldn't do any of the things that Access will do automatically, eg updating the record after you've edited it.

Sorry for being long-winded and it might sound a bit complicated, but it isn't.

Most of what I've described could be done using the wizards, even generating some of the code.

Though just sort of like the macro recorder in Excel you might want to tweak what's generated.

 

[MrKowz]

Thanks for the info, Norie. I'll look into these options.

As I said, I'm very new to Access and have to learn as I go. I really should stop by Barnes and Noble and pick up an Access for Dummies book.