Forms-Appropriate Control to Use

S

SueW

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.
 
P

PieterLinden via AccessMonster.com

SueW said:
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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Forms 0
How to use/create code in MS Word to calculate age? 0
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Access 2007-Duplicate Record Field Capability 2
Lookup Field 2nd Column 2
Access 2007-Table not displaying the values from a combo box 2
Dynamic Naming of Form Button 3
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top