VB has problems

[tggsun]

Hello,
This is my first time to write VB code. I want to open a new form to enter data if I choice a specific value for a field from a dropdown list. So I wrote the following VB code:

Private Sub Combo78_AfterUpdate()
if FATALISM_Q6="Accu"
then DoCmd.OpenForm "Accu"
End If
End Sub

This one has problem to be used since it can not pass VB editor. But I don't know how to figure it out. Is there any one can tell me how to figure that out?



Many Thanks........!
DD sf

[pbaldy]

Try:

if FATALISM_Q6="Accu" then 
  DoCmd.OpenForm "Accu"
End If

[aytee111]

Where is FATALISM_Q6 coming from? Should it read Me!Combo78 instead?

(Hint Give your controls names that make sense, Combo78 means nothing and will cause you confusion in time, especially if you start adding multiple combo's)

[tggsun]

thank you all. it works now.
DD sf

[tggsun]

Hi guys,
the following VB works fine.
Private Sub Combo78_AfterUpdate()
If Combo78 = "Accu" Then
DoCmd.OpenForm "Accu"
End If
If Combo78 = "Audit" Then
DoCmd.OpenForm "Audit"
End If
End Sub

I want to add more functions on this:
1). when VB open a window, I need to automaticly clear/or setup a field as empty of the row. (say field_empty="")
2). when I need to close the opened form, I need to automatical save the values which I entered.
Thanks,
DD sf

[tggsun]

Also want to know if there is a reference book that can let me check out those VB command. And/or is there any good book for training?
Thanks,
DD sf

[aytee111]

1) Depends what your form looks like - is it bound to a table? Is it columnar or datasheet? If it is bound to a table and you are going to a new reocrd then it will automatcally be empty (null)

2) It is automatically saved as soon as you leave the record - if it is already bound to a table

I don't know of any good book - VBA for Dummies?