automaticly fill textbox value based on client info

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

Guest

I am trying to figure out how to automatically fill textbox values on my
Client services form based on which client I select. I can make a query to
get the info, but I can't get it onto my form. Is there a VB command or and
expression I can use to get the data to automatically fill certain fields in
my form?
 
I am trying to figure out how to automatically fill textbox values on my
Client services form based on which client I select. I can make a query to
get the info, but I can't get it onto my form. Is there a VB command or and
expression I can use to get the data to automatically fill certain fields in
my form?
Click to expand...

Are you trying to copy client information from the Clients table into
the ClientServices table? If so - DON'T. Storing the information
redundantly is neither necessary nor beneficial. Typically if you have
multiple Services for one Client, you would use a Form based on the
clients table (showing the client information right there) with a
Subform based on the services table, to add the service table records.

If this is impractical, you can *display* fields from the client table
by using a Combo Box based on the clients table, containing all of the
fields you want to display (up to ten); you can put textboxes on the
form with control source

=comboboxname.Column(n)

where n is the *zero based* subscript of the field in the combo's row
source query. This information will not be stored, but then it
shouldn't be in the first place!

John W. Vinson[MVP]
 
Back
Top