Assign ID to one field based on another field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharonInGa - 16 Nov 2005 16:01 GMT

The two fields are customer and BookingNo. IF the customer = "A" then I need
the BookingNo to be populated with any five digit character. IF the customer
is anything else, I need the same BookingNo to = null. Please include code
in your answer.

Reply to this Message

Ofer - 16 Nov 2005 16:27 GMT

Try this code, on the after update event of the customer field

If Me.[Customer field name] = "A" Then
Me.[BookingNo field name] = "ABCDE"
Else
Me.[BookingNo field name] = ""
End If

Please enter in the brackets the name of the fields in your form

Signature

I hope that helped
Good Luck

> The two fields are customer and BookingNo. IF the customer = "A" then I need
> the BookingNo to be populated with any five digit character. IF the customer
> is anything else, I need the same BookingNo to = null. Please include code
> in your answer.

Reply to this Message