Auto populating or filtering using macros

[kashishsinha]

I have two tables tblEntity and tblFilling. tblEntity contains the fields CIK, EntityName and tblFilling has the following CIK, Form type, Accession Number etc

I have created a form with the combo box for CIK and Entity name. I want the fields in the tblFilling to be shown automatically based on that we select. I ve seen examples using Vb but couldn find anything using macro

I also wanted to know if we could autopopulate the fields in a data sheet rather than text boxes. I am a novice to it so do not hav much idea

Thanks
Kashish

 

[mahenkj2]

Does these two tables have relationships established? Since you have same CIK in two tables then assume you have done so.

In that case, it should be possible to fill the related fields automatically and should not require any VBA code. You need to use a query as recordsource based on these two tables.

In case you have more troubles, please post a sample dB.