Automatically Populate Fields on a Form

[Guest]

I'm still trying to accomplish this. I've followed (in part) the
instructions provided by Andy -- I based the form (the one I'm trying to
automatically populate) on a query rather than a table. Andy, I hope you
will view this so I don't have to provide all of the background info again.
I have the on-click property of the command button that brings the form up
attached to a macro. The macro opens the form and in the "Where" section of
the macro I've put: [ClientRepCode]=[Forms]![Client Representatives ONLY -
From Query w/o lookup]![ClientRepCode]. It does take me to matters for the
current representative, but still won't automatically populate the RepName
and RepCode fields. Is there anything I can add to the macro to do this?
I've tried inputting the code (modified with exact names of forms and fields,
of course) that you suggested, but I keep getting errors. Thanks to all for
the input.
Ruth Enright

 

[Guest]

Ruth,

The first thought would be are those values right there in the forms source
query so that you can simply grab them and place them in the form fields you
want to display them in? If those values are not readily available in your
forms source query then you could pass them in the opening args or in a
global variable or another option would be to have a function execute when
the form opens that goes into the system to retrieve those values wherever
they are based on some available variable in the forms query. If Andy does
not get back to you and this is not helping please post again and I will try
to better understand what is going on.