Automatic Population of Certain Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get these fields to populate automatically?

Background:
I have a bridge table in this db due to the necessity of a many-to-many
relationship (there are clients and there are client representatives -- there
are several divisions of particular clients and the client representatives
can work for more than one division)

Problem:
I have a Main Client Form
There is a Subform on the Main Client Form which lists the Client Reps for
that particular division of a client.
By double-clicking on the client-rep-number field on the Subform, a form
opens up ("Client Rep Only") that has more complete information about that
particular client rep.
There is a command button on the "Client Rep Only" form that opens up a
listing of the particular matters that client rep is responsible for. While
it does indeed bring up the appropriate matters on the "Rep-Matters" form, it
does not populate the fields with the first and last name for that client rep.

Could the problem be that I have concatenated fields in the query for the
"Client Rep Only" form? I'm using Access 2002.
 
Hi Ruth

A few questions?
How are you getting the Rep-Matters form to open? What is the code?
What is the Source for the Rep-Matters form? Is it a query or table and does
that source contain the rep first and last name?

I would expect the Rep-Matters form to be based on a query that contains the
rep first and last name and the form with the button should "tell" the
Rep-Matters form the RepID (or whatever you called it) so it shows the
correct rep's matters.

I would expect your button to run code like the following...

DoCmd.OpenForm "Rep-Matters", acNormal, , "RepID = " & Me.RepID

I have assumed the form with the button on contains a reference to the
particular rep which i have called RepID. So, the last parameter above tells
the Rep-Matters form to apply a filter using the chosen RepID.

Hope this helps in some way

Andy Hull
 
Back
Top