I am creating a form that displays a select query in a sub form, and I wish to display the current record of the sub form, matching fields with corresponding text boxes or labels that are easy to read. Both main and subform data sources are the same query. qry_RateCode_NM
I would like to set the record source to something like
for each field on both forms. but even if the main form is unbound I still cant get the text boxes or labels to display or update the active record of the subform.