I have a main form (its record Source is a table, HC_Comp_Records_Table) called HC Forms and a sub form (its RecordSource is a table named HC_Product_Species_Table with column headings, Product_ID, Product_Type, Species, Net wt and Comp_ID), HC Species Subform which is set to open in continuous view. One the main form is a combo box called Company Name (its row source is a table called Companies List) which contains list of companies. There are two cascading combo boxes named ProductType (It's row source is a table, CompProductType table) and Species (Its row source is also a table, SpeciesListTable) on the subform. The values in ProductType depends on Company Name.
I have superimposed a textbox (txtSpecies) on the combo box Species
So far, at the point of data entry, the data I will select on the subform is visible. However, the subform becomes blank when the form opens or I navigate through records.
I have been searching the internet for almost a week now but no luck. I understand its difficult working with continuous forms as subform. Any help will be greatly appreciated
I have read through similar posts but i still cannot get mine to work
Database attached
I have superimposed a textbox (txtSpecies) on the combo box Species
So far, at the point of data entry, the data I will select on the subform is visible. However, the subform becomes blank when the form opens or I navigate through records.
I have been searching the internet for almost a week now but no luck. I understand its difficult working with continuous forms as subform. Any help will be greatly appreciated
I have read through similar posts but i still cannot get mine to work
Database attached