How do I set up a value based on another box's value in access?

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

Is there a reason you can't have one combo box with 4 columns instead of 4
separate combo boxes ?

"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

I need to show all 4 items in a report, can it be done in one combo box. I
only know how to show one of the values in a combo box?
When I set up the table I set up different fields for sorting reasons.
Thank you!

"Dennis" wrote:

Is there a reason you can't have one combo box with 4 columns instead of 4
separate combo boxes ?

"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

Yes you can, whatever is selected in the combo box you can get at the other
columns like this

=ComboBox.Column(1)
=ComboBox.Column(2)
etc.

"idontgetit" wrote:

I need to show all 4 items in a report, can it be done in one combo box. I
only know how to show one of the values in a combo box?
When I set up the table I set up different fields for sorting reasons.
Thank you!

"Dennis" wrote:

Is there a reason you can't have one combo box with 4 columns instead of 4
separate combo boxes ?

"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
....etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

Thank you very much for your help!! One questions I have than is when I'm
entering both Bob Smith and Sam Smith in a form to enter b-day's- I only show
Smith and not sure which one b/c I don't have that other field showing.


"Sprinks" wrote:

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
...etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

Is the name a combo box or a textbox? If it is a textbox, change the
ControlSource to [LName] & ", " & [FName] to display the full name, or add
another textbox for the other field.

If it is a combo box, change the RowSource as I suggested in my earlier post.

Sprinks

"idontgetit" wrote:

Thank you very much for your help!! One questions I have than is when I'm
entering both Bob Smith and Sam Smith in a form to enter b-day's- I only show
Smith and not sure which one b/c I don't have that other field showing.


"Sprinks" wrote:

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
...etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

I'm sorry if I'm hard to understand, thank you for your patience and this is
the last question.

It's a combo box- I understand the bound column, but can i make it show more
than one column? When I bound to the first name (column 2) only the first
name comes up, not Smith AND BOB. ????
Thank you!

"Sprinks" wrote:

Is the name a combo box or a textbox? If it is a textbox, change the
ControlSource to [LName] & ", " & [FName] to display the full name, or add
another textbox for the other field.

If it is a combo box, change the RowSource as I suggested in my earlier post.

Sprinks

"idontgetit" wrote:

Thank you very much for your help!! One questions I have than is when I'm
entering both Bob Smith and Sam Smith in a form to enter b-day's- I only show
Smith and not sure which one b/c I don't have that other field showing.


"Sprinks" wrote:

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
...etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

I'm not sure what you're trying to do.

Please post your combo box' RowSource property, and the name of the form's
RecordSource property.

Sprinks

"idontgetit" wrote:

I'm sorry if I'm hard to understand, thank you for your patience and this is
the last question.

It's a combo box- I understand the bound column, but can i make it show more
than one column? When I bound to the first name (column 2) only the first
name comes up, not Smith AND BOB. ????
Thank you!

"Sprinks" wrote:

Is the name a combo box or a textbox? If it is a textbox, change the
ControlSource to [LName] & ", " & [FName] to display the full name, or add
another textbox for the other field.

If it is a combo box, change the RowSource as I suggested in my earlier post.

Sprinks

"idontgetit" wrote:

Thank you very much for your help!! One questions I have than is when I'm
entering both Bob Smith and Sam Smith in a form to enter b-day's- I only show
Smith and not sure which one b/c I don't have that other field showing.


"Sprinks" wrote:

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
...etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!

I have one table (Tbl_Names and Info) with fname, lname, bday, start date,
etc. that holds all the personal records. I can pull all kinds of reports
from this- b-day for the month, etc.
What I'm trying to do is : pull Bob Smith from (Tbl_Names and Info) and
enter any expenses that we owe them. When I do a combo box I can show the
first and last name (Bob Smith) but b/c these are two different fields, I can
either get the first or last name in as the value. I have to set up another
combo box for Bob and select the another combo box for Smith. Can I set this
up so that when I select Bob- Smith drops into it's own value?
I hope I'm explaining this enough? If not, let me know.
Thank you very much for your time!

"Sprinks" wrote:

I'm not sure what you're trying to do.

Please post your combo box' RowSource property, and the name of the form's
RecordSource property.

Sprinks

"idontgetit" wrote:

I'm sorry if I'm hard to understand, thank you for your patience and this is
the last question.

It's a combo box- I understand the bound column, but can i make it show more
than one column? When I bound to the first name (column 2) only the first
name comes up, not Smith AND BOB. ????
Thank you!

"Sprinks" wrote:

Is the name a combo box or a textbox? If it is a textbox, change the
ControlSource to [LName] & ", " & [FName] to display the full name, or add
another textbox for the other field.

If it is a combo box, change the RowSource as I suggested in my earlier post.

Sprinks

"idontgetit" wrote:

Thank you very much for your help!! One questions I have than is when I'm
entering both Bob Smith and Sam Smith in a form to enter b-day's- I only show
Smith and not sure which one b/c I don't have that other field showing.


"Sprinks" wrote:

In a relational database, you want to store "attributes" (fields) of "things"
(tables) ONCE. It sounds like you're trying to store the Birthday, LName,
FName, and YearsEmployed in some table other than the Employee table. For
example, an Employee table might have the fields:

EmployeeID AutoNumber (Primary Key)
FName Text
LName Text
Birthday Date/Time
YearsEmployed Integer
Phone Text
Extension Text
WorkGrade Text
Salary Currency
...etc.

If you wish to have an Employee field in ANY OTHER table, all you need to
store is the primary key EmployeeID field. All other fields can be obtained
for a report or for display on a form through a query, or by including them
as columns in a combo box, and using the Column property to display them in
other UNBOUND textboxes.

So what you need is a single combo box Bound to a numeric field, and
textboxes to display other columns that you include in the Row Source of the
combo box.


Combo Box Properties
---------------------------
RowSource SELECT EmployeeID, FName, LName, Birthday, YearsEmployed FROM
YourTable
ORDER BY LName, FName;
Bound Column: 1
Column Count: 5
ColumnWidths: 0";x",y";0",0", where x and y are large enough to display the
widest FName & LName, respectively

To display another column in any unbound textbox, set its ControlSource to:
=YourComboBox.Column(x), where x is the column number, starting from zero
(for example, the third column's index is 2).

Two other comments:

- YearsofService would be better implemented by calculating it from a
HireDate.
- You may wish to combine the FName and LName for display in the combo box.
The EmployeeID will still be stored. The RowSource would then be:

SELECT EmployeeID, LName & ", " & FName AS FullName, Birthday, YearsEmployed
FROM YourTable
ORDER BY FullName;

Hope that helps.
Sprinks



"idontgetit" wrote:

I have worked on this problem for over a year and still have not conquered
it. Any help would be very much appreciated.
I have a form that is set up from a table. There are 6 combo boxes. Of the
6 combo boxes 4 of them refer to the same thing. Example: I have one box
for Joe (first name), one box for Smith (last name) another box for his
birthday and the last box for his years employeed. I set up the combo box so
that I have to click on each one individually and each time (4 times) and
click on Joe, Smith, b-day and years employed.
Is there a way to set the other 3 boxes based of the value that I select for
Joe. I have included all the information in every combo box to make sure I'm
pulling the right Joe.
Any ideas?
Thank you VERY MUCH!