Duplicating (1 Viewer)

K

kumark

Registered User.

Local time

Today, 12:13

Joined

Feb 22, 2012

Messages

22

• Jul 10, 2012

• #1

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.

 

Attachments

• 
  Work.jpg

  31 KB · Views: 82

John Big Booty

AWF VIP

Local time

Tomorrow, 05:13

Joined

Aug 29, 2005

Messages

8,263

• Jul 10, 2012

• #2

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;

 

Attachments

• 
  Capture.JPG

  31.6 KB · Views: 190

V

vbaInet

AWF VIP

Local time

Today, 20:13

Joined

Jan 22, 2010

Messages

26,374

• Jul 10, 2012

• #3

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