Auto Fill In

[Guest]

I have a form that works off of a two table query. They are joined in a one
to many. I can fill in a field called "equip" and when I fill this field in
it automatically fill in a field called "description" everything works great.
I go to my form and populate the same "equip" field with the same data and
nothing goes into to the "description" field. When I go out of the program
and come back it fills it in but I want it to be populated immediatly just
like the query does.

 

[Guest]

Well, since I got no replies I thought I better fix it myself. So I tried a
few of the suggestions on the newsgroup but none of them worked for me then I
went to the Control Source of the field I wanted to be Auto filled and put in
the Combo Box name and which column I wanted populated and it works. example;
=cboAsset.Column(1) the columns start with zero "0" "1" etc.

 

[Guest]

Try this - In the property "After Update" for your EQUIP field of the form
create event -
DoCmd.Requery

 

[Guest]

I was so proud of myself. I thought I had solved my problem but found out I
couldn't Filter By Form. I then changed and used the DoCmd.Requery. Now I
can use the Filter By Form.

Thanks