Field Completion

[Guest]

I'm trying to follow the basic premise of this article
http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx

Basically, I have a form where you select a choice from a combo box and 20
other fields are automatically filled in based on the information in a query.
I've setup the query to contain all the information and filtered it using
the code [Forms]![Portfolio]![Portfolio] which I'm thinking is telling it to
only return the values that correspond to the combo box choice. The query
works if I run it by itself and enter the parameter at the begining.
However, the form isn't being filled in with the data when I try to make the
two work together. Any ideas about how this could be done differently or how
to make this method work? Thanks.

 

[John Vinson]

I'm trying to follow the basic premise of this article
http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx

Basically, I have a form where you select a choice from a combo box and 20
other fields are automatically filled in based on the information in a query.
I've setup the query to contain all the information and filtered it using
the code [Forms]![Portfolio]![Portfolio] which I'm thinking is telling it to
only return the values that correspond to the combo box choice. The query
works if I run it by itself and enter the parameter at the begining.
However, the form isn't being filled in with the data when I try to make the
two work together. Any ideas about how this could be done differently or how
to make this method work? Thanks.

Please post your code and the Recordsource of your form.

John W. Vinson[MVP]

 

[Guest]

The record source for my form is a table but the control source for the
fields is the query (hopefully). I don't know what you mean by my code.

I'm trying to follow the basic premise of this article
http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx

Basically, I have a form where you select a choice from a combo box and 20
other fields are automatically filled in based on the information in a query.
I've setup the query to contain all the information and filtered it using
the code [Forms]![Portfolio]![Portfolio] which I'm thinking is telling it to
only return the values that correspond to the combo box choice. The query
works if I run it by itself and enter the parameter at the begining.
However, the form isn't being filled in with the data when I try to make the
two work together. Any ideas about how this could be done differently or how
to make this method work? Thanks.

Please post your code and the Recordsource of your form.

John W. Vinson[MVP]

 

[John Vinson]

The record source for my form is a table but the control source for the
fields is the query (hopefully). I don't know what you mean by my code.

Just a combo box won't do anything about filling 20 other fields. How
do you have it set up to do so? Is there anything in the AfterUpdate
event of the combo box? If it says [Event Procedure] please click the
.... icon by it and post the code here.

John W. Vinson[MVP]