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

[Brian Bastl]

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

 

[Try Hard]

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)

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

I have created a table which contains info about facilities; sample lines
are:
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!