creating update forms

[defosset]

i need to design a form that i can search my database
and update the name and address information in my database
is this as simple as designing an update query and implementing this into a form. I want it set up where
the doner id is entered

and only the fields that need to be changed or updated
are filled in and all other are left blank.
(if fields are left blank in an update query is it updated to be a blank and the data that once in that field is now erased or does the data stay.

thanks
nick

 

[WildHare]

1) any fields not referred to in an update query will NOT be affected.

2) Build your form using a standard select query, using whatever fields you want to display out of the base table.

3) When you bring up a record and make any change, the change(s) will automatically be reflected in the real table.

You do NOT need a separate update query for any of this.

You can place a combo box on the form for quick search/find capabilities as well.

Don't make things harder than they have to be.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm