Updatable field (Access 2000)

Topic

New Reply

In my query i have felds A and B. Can i create the filed b to be updatable from field A and how can i do it ? I mean any value entered in A to be equal to B

Reply | Quote

Replies

If you want B to be equal to A, why do you need B at all?

Reply | Quote

B is linked with another table.B is the availaility in the house and A is the demand order.If we decide to change the demand we want to change at the same time its availablity.because after that we are updating the available quantiies.We are then sending B back.

Reply | Quote

You’d have to do this in a form, you cannot do it in a query.
Create an AfterUpdate event for the text box bound to field A:

Private Sub A_AfterUpdate()
Me.B = Me.A
End Sub

You must use the real names for A and B of course.
When the user changes the value of A, that of B will be updated too. The value of B can be edited by the user after that.

Reply | Quote