Linking two fields on the child form

[rajeshsarin]

I have a subform called payment, which is linked to parent form (client).

When users select the value EFTPOS using the drop down box called method, I want that they must then fill a value in the box Trans_No.

If they choose any other value using drop down box called method, then we can set the value of Trans_No as NA (not applicable).

How do I achieve this?

 

[MStef]

Look at "DemoTwoFieldsA2000.mdb" (attachment, zip).
Open Form and try.
Look at VBA.

 

[rajeshsarin]

Works like a Dream, Thanks Mate !!!