Multiple queries on one field ?

[pookie62]

Hi,
I got several queries which all can apply to the same field, I was testing with this:

Private Sub Provisie_BeforeUpdate(Cancel As Integer)
Dim Fee As Integer
If Me.VerzId = 1 Then
    DoCmd.OpenQuery "ProvBerekGelders"
   Me.Provisie = Fee
   End If
End Sub

But it's not exactly what it should be.
I want the fieldvalue filled with the calculated value from the query.
How do I do that ?

AND !

How to set it that depending on the Me.VerzId value a different query is read and thus filling the field Me.Provisie with a different value from different Query

 

[Dennisk]

use the query as the recordsource of a recordset, open the recordset and read the value.

 

[pookie62]

Don't know what you mean.. sorry..
Was thinking in the CASE SELECT direction.. isn't that an option ?
If the piece of code I wrote is correct, which I think it isn't...