filling a control in a continuous form with a field from a table

[m galvin]

I had posted this under "Access Reports" in error and received a response and
responded. Please follow the dialog for an explaination of my question:

Original Question:
I have a form with the fields: date, client, atty, time, billable and
description. All these fields update the Time Sheet Table.

I want the atty field to automatically take the attorney's name from the
table Attorney which contains one field called Atty.

So for I can only figure out how to use a combo box to chose the Attorney
table field.

Response Received:
Your combo box to select the atty value can be set to display the atty, the
name, or both based on the Row Source, Column Count, and Column Widths. You
only want to store the atty field.

Response to Response:
I do that now. I want to eliminate the combo box. I want the control to
show the atty's initials without having to use a combo box. Example: when
the user opens the form the would see: Date: blank box, Client: blank
box, Atty: DH (using your initials for this example), Time: blank box,
Description: blank box. All the controls except for Atty would be tab stops
and the user would input the info. The initials (DH) displayed in the Atty
control I am trying to use the source Attorney Table, Atty Field in the
Table. I can not figure out how to do this. With the combo box I am using
now the user selects the atty's initials from the drop down list. In this
case the list would list only one set of initials, DH, which is the only
atty stored in the Attorney Table.
________________________________________
Is there a solution?

 

[Douglas J. Steele]

Create a query that joins your Time Sheet table to your Attorney table and
use that query as the recordsource for your form.

 

[tom_willpa]

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com