Duplicating

[kumark]

Hi All,


I have 2 Columns MFGID and VENDID. where ever MFGID is Null the Corresponding cell Vendid should get updated and VICEVERSA. on the Clik of the button in the Form it should get updated . i have enclosed the attachment of it.

 

[John Big Booty]

What you will need to do is create a couple of Update queries that use Is Null as criteria and then updates the relevant filed.

It will look something like;

 

[vbaInet]

Another ways is to use the Nz() function in which case you wouldn't need to update the table.

http://www.techonthenet.com/access/functions/advanced/nz.php