Help with displaying field B and C, based on field A

Hi Claire,

You should really stick with your other thread " locking fields ...." The
help I can provide would seem completely amatuerish compared to the help you
will receive from Steve Schapel, Microsoft Access MVP or any other Access
MVP for that matter. Just respond to his post if you want further
assistance.

Brian

"Claire Rohan" u17677@uwe wrote in message news:5a67ad82cdb0a@uwe...
Hi Brain,
You seem to know lots about this so Im hoping you might be able to help me
too - I have created a combox in my main Trade Details form which is used
to
get values for a number of text boxes ie the combo box for Client also
selects the commission rate and interest rate for that client from the
Client
table.
I want to be able to fill out the rest of the details in the Trade Details
form and then when the form is completed to lock all the fields including
the
values of the commission rate and interest rate. It will be the case that
at
a later stage I will change the rates in the Client table but I want the
rates in the Trade Details form to stay as they were when I completed the
form. Is this possible?

Brian Bastl wrote:
Hi Sandy,

first off, columns are zero-based, meaning that the first column would be
referenced as Column(0) and the second column as Column(1), and so on.

Secondly, do you have primary key defined in your Realtors table...
something like RealtorID? I'd bring that into the rowsource and set that
as
your bound column.

Combo Row Source =
SELECT Realtors.RealtorID, Realtors.RealtorName, Realtors.RAgency,
Realtors.RPhone, Realtors.RExt, Realtors.RMobile, Realtors.REmail,
Realtors.RAddress, Realtors.RCity, Realtors.RState, Realtors.RZip FROM
Realtors ORDER BY Realtors.RealtorName;

Bound Column = 1 'RealtorID
Column Count = 11
Column Widths = 0";2";2";0";0";0";0";0";0";0";0"; 'the combo will only
display the realtor's name and Agency.

And lastly, you don't need to have anything for the control source of the
text boxes. I'd "push" the values into the corresponding text boxes in
the
AfterUpdate event of your combobox.

Example:
Private Sub YourCombo_AfterUpdate()
Me.txtRealtorName = Me.YourCombo.Column(1)
Me.txtRealtorAgency = Me.YourCombo.Column(2)
Me.txtRealtorPhone = Me.YourCombo.Column(3)
etc.
End Sub

HTH,
Brian

The information given I could even understand which is great,but the
textboxes shown are for display. How can I have what I have selected in these
textboxes put into the same table as the combobox (ie. next to the combobox
selection)

"Wayne Morgan" wrote:

Try making the control for the Golf Course field a combo box. This will let
the user type the name or select it from the drop down list. Add the other
columns to the combo box. Place 2 textboxes on the form and set their
control source to the appropriate column in the combo box. They will then
display the Chapter and Facility. Since they will be calculated controls,
they will be read only.

Setup:
Combo Box
Row Source: SELECT [Course ID], [Golf Course], Chapter, Facility FROM
tblTableName ORDER BY [Golf Course];
Bound Column: 1
Column Count: 4
Column Widths: 0";0.5";0";0" (adjust the 2nd one as needed to display the
full names)
LimitToList: Yes
Control Source: The field in the form's Record Source that you want the
Bound Column
(the ID column) value stored in when you make a
selection.

First Textbox
Row Source: =cboComboBox.Column(2)

Second Textbox
Row Source: =cboComboBox.Column(3)

The Column property is zero based, so 2 is the 3rd column and 3 is the 4th
column.

--
Wayne Morgan
MS Access MVP


"brianlas" wrote in message
...
I have created a table which contains info about facilities; sample lines
a
Course ID Golf Course Chapter Facility
1 ABC X3 Salinas
2 XYZ Y4 San Jose
etc.

I have a form with the Golf Course, Chapter and Facility fields. What I
want
is for someone to enter the Golf Course name, and based on the name,
automatically display (update) the Chapter and Facility fields on the form
I.e., pull them from a table and update them. Ideally, I would also like
to
make the Chapter and Facility fields "Read-only". Please forgive me if
this
is a stupid question, but I've been racking my brain over this for a bit
too
long. Thanks for anyone's help!