Client Form

[krc547]

I have a form that I need to set up that has three drop down lists. One is a
list of company social workers, one is a list of county social workers and
one is a list of foster homes. I have setup tables for each of these. I have
built relationships to the client table but when I change the item on my form
to a list box no list appears in form view.

 

[Maurice]

Comboboxes are not filled when changing a textbox to a combobox. The combobox
control has an own rowsource which usually exists of a query or a codetable.
Depending on the option of which control you want to make a combobox you
have to think about your tables to see which field should fill the combobox.
After some 'digging' you'll find that this field is in most cases a seperate
table. So look into the design again.

Let us know what should appear in the comboboxes and what you want the
comboboxes to do...

hth