Auto Fill text box based on other text box on form (1 Viewer)

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

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