Prev: Embedded Acrobat Viewer
Next: Delay in an action for certain time and then let it execute
From: SueW on 9 Mar 2010 15:55
I would like to place a control on a form so end user can select a name from
the Clients table that has the fields: client, address, city. In a
subsequent field choose the client address and city.

Field: Client
Field: Client_Address_and_PhoneNumber

The goal is a report showing appointments for drivers for the day.
From: PieterLinden via AccessMonster.com on 9 Mar 2010 17:39
SueW wrote:
>I would like to place a control on a form so end user can select a name from
>the Clients table that has the fields: client, address, city. In a
>subsequent field choose the client address and city.
>
>Field: Client
>Field: Client_Address_and_PhoneNumber
>
>The goal is a report showing appointments for drivers for the day.

Sounds like you want a cascading combobox. This article explains how to do
it.
http://www.mvps.org/access/forms/frm0028.htm

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Embedded Acrobat Viewer
Next: Delay in an action for certain time and then let it execute