I have a form 'Form A' and a subform "Form B".
The subform is master and child linked by a field called IP Address.
the subform "Form B" references the following fields:
IP Address
Date
Meter Read
I want Form A to show the first record from the subform; it should show the value of the field 'Meter Read".
I know I need to add a text box in the form and use Builder but I do not know how to write the function correctly.
the main form "Form A" references IP address and I connected both tables in my relationship table.
The subform is master and child linked by a field called IP Address.
the subform "Form B" references the following fields:
IP Address
Date
Meter Read
I want Form A to show the first record from the subform; it should show the value of the field 'Meter Read".
I know I need to add a text box in the form and use Builder but I do not know how to write the function correctly.
the main form "Form A" references IP address and I connected both tables in my relationship table.
