I have 2 forms in my db. The first one should look up a record by the first field and display the rest of the fields if the record is found. It should then display the subform record that it is linked to.
I am having trouble getting the record to display the fields after inputting the data...