Updating partial data on a normalized database...

[Jason1983]

I have a Search form which gets data from the tables that were filled from different forms earlier ....This data entered could be partial data....I mean for example...

Name --- Entered
Address -- Entered
City --- Entered
State --- Entered
ZipCode --- Not Entered Initially
Telephone --- Not Entered Initially
Fax ---- Not Entered Initially

So i search and these results gets displayed based on the data being present..If i want to edit this displayed data....i have put a edit button on the form....So how can i update this data....Please give a sample......Ple ase help....

Thanks...
Jason.....

[NeoPa]

...Please give a sample......Ple ase help...

Samples generally not provided as this is a site for giving assistance rather than doing for you.
However, there is some code in Example Filtering on a Form. This doesn't do exactly what you need but it should point you in the right direction. You may even decide, after looking at it, that it meets your needs better than your current idea. I'll leave it for you to decide.

Good luck.