Not sure?

[René]

We have clients that live in certain facilities, nsg homes, assisted livings etc. ON the main client form we type in directions to their individual addresses

Right now I am using a combo box to list the names of the facilities where we have client's. Is there any way to have the directions transfered to the Directions field on the Client Form if the Facility field is used
Thank

 

[Jeff Boyce]

René

From your description, I still don't have a very good picture of what your
table structure is like. If you'd like specific instructions on moving data
from one field to another, please describes your tables involved.

By the way, you are talking about moving, not just copying, right?

 

[René]

I have two main tables, a client table and an employee table, there are smaller tables for employee requirements and client service requirements etc.

Our clients live either at home or in a facility of some type ie. nursing home, assisted living or retirement community. The particular combo box that I'm referring to is a table listing of the names of all the different facilities in our area.

On the main client form, I have a field for directions to their individual homes along with another field for the map # from a unified map book that we use. I would like to have the directions copied(transfered) to the Direction field if the person lives in one of the facilities so that data entry doesn't have to be done when more than one client lives in each facility. This would also allow the directions to be associated with the particular client when a Care Plan is printed.

If this is not possible, how can I have a list/combo box that when you choose the facility a small sub-form would pop up with particulars about the facility ie directions/address/phone # etc. Possibly allow you to copy/paste the directions and then disappear after tabbing through or clicking on a field in the main form

Any ideas would be great!

 

[Jeff Boyce]

If I understand correctly, you have directions to a specific facility, and
you are trying to copy those directions to an individual client.

If so, don't! If you have already indicated which facility a client is at,
use a query to get that facility's "directions".

I didn't see a mention of a table of facilities -- have you build a combo
box of facility names that is a "value list"? If so, don't! Build a table
of facilities, each with its own info (say, directions, contact person,
phone number, etc.), and use the FacilityID number to show where a client is
located.