Hi Everyone

I don’t have that much VB experience, maybe someone can help me. I have 4 variables called: A, B, C and Z, what I want to do is update Z with the value of A when A is not blank and B and C is blank, other wise if A and B is both not blank and C is blank then Z should be updated with B's value and so on, the table's name is TBL. Below is the code that I have tried and failed, could someone please help me?


Private Sub Command0_Click()
Dim A As String
Dim B As String
Dim C As String
Dim Z As String

A = [TBL].[A]
B = [TBL].[B]
C = [TBL].[C]
Z = [TBL].[Z]

    If (A Is Not blank And B Is blank And C Is blank) Then Z = (A)
End If
End Sub


Thanks
Hennie

Does anyone have an idea for me?

How do you want to do this? Do you want it to happen when someone fills out a form, or are you trying to update lots of records in an Update query, etc?

It would be easy in an update query on the table. You could do this in a series of Update queries just to make it very easy:

Update query:
A criteria: <>""
B criteria: <>""
C criteria: =""
Z update: [A]

Then just run the query.

Does this help?






mmcdonal