Auto Fill text box based on other text box on form

[Oka Mahendra Saputra]

Dear sirs,

I have created 2 forms (on attachment called as "form user' and 'form input') based on data from 1 table (on attachment called as "table"). The Primary Key is the ID field on far left side. User will only interact with both forms. I want to create automatic fill on 'form input' STATUS field based on input in 'form input' BATCH field ; when user input BATCH number, the STATUS field will automatically turned into 'AVAILABLE'. Any advise on how to do it sir?

Regards,
Oka

 

[arnelgp]

You can either use AVAILABLE as Default value for status or add code to Batch Number's Before Update event:

Private sub batch_BeforeUpdate(Cancel As Integer)
If trim(Me.Status & "")="" Then _
Me.Staus="Available"
End Sub