automatically poulate fields

[JR]

I am creating a Inventory database and I have a model number field a Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and memory
information. When I put the model number in its field I want the other fields
to be automatically populated with the standard configuration information.
how do I do that.

 

[BruceM]

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count to 3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1) is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that will
yield satisfactory results, but I won't go into other options unless there
is a need.

 

[JR]

Thanks Bruce

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count to 3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1) is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that will
yield satisfactory results, but I won't go into other options unless there
is a need.

I am creating a Inventory database and I have a model number field a Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and memory
information. When I put the model number in its field I want the other
fields
to be automatically populated with the standard configuration information.
how do I do that.

 

[JR]

I have tried and it seems that I can't get the 2 and 3 column to fill in. I
followed your instructions and I can't seem to get it to work. I am using MS
Access 2003 if that makes a difference...

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count to 3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1) is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that will
yield satisfactory results, but I won't go into other options unless there
is a need.

I am creating a Inventory database and I have a model number field a Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and memory
information. When I put the model number in its field I want the other
fields
to be automatically populated with the standard configuration information.
how do I do that.

 

[BruceM]

Post the Row Source SQL. If it is a named, query, open the query, then
click View >> SQL. Copy what you see there, and paste it into your
response, along with the query name.

Provide the following information about the combo box:
Name
ControlSource
Row Source
Bound Column
Column Count
Column Widths

Post the Control Source of the text box in which you would have Chip Speed
appear, and the same for the Memory text box.

I have tried and it seems that I can't get the 2 and 3 column to fill in. I
followed your instructions and I can't seem to get it to work. I am using
MS
Access 2003 if that makes a difference...

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count to
3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the
combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1) is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that will
yield satisfactory results, but I won't go into other options unless
there
is a need.

I am creating a Inventory database and I have a model number field a
Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and memory
information. When I put the model number in its field I want the other
fields
to be automatically populated with the standard configuration
information.
how do I do that.

 

[JR]

SELECT Table2.ModeNo, Table2.ChipSpeed, Table2.Memory
FROM Table2;

Name Combo0
ControlSource Blank
Row Source Select[Table2 Query].ModelNo, [Table2 Query].ChipSpeed, [Table2 Query].Memory From [Table2 Query];
Bound Column 1
Column Count 3
Column Widths 1";0";0"

The Text Box has the following :

Control Source: =cboModelNo.Column(1)

Post the Row Source SQL. If it is a named, query, open the query, then
click View >> SQL. Copy what you see there, and paste it into your
response, along with the query name.

Provide the following information about the combo box:
Name
ControlSource
Row Source
Bound Column
Column Count
Column Widths

Post the Control Source of the text box in which you would have Chip Speed
appear, and the same for the Memory text box.

I have tried and it seems that I can't get the 2 and 3 column to fill in. I
followed your instructions and I can't seem to get it to work. I am using
MS
Access 2003 if that makes a difference...

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count to
3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the
combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1) is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that will
yield satisfactory results, but I won't go into other options unless
there
is a need.

I am creating a Inventory database and I have a model number field a
Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and memory
information. When I put the model number in its field I want the other
fields
to be automatically populated with the standard configuration
information.
how do I do that.

 

[BruceM]

Since the combo box is named Combo0 the Control Source needs to be:

=Combo0.Column(1)

As a suggestion, meaningful names for combo boxes and other controls make
coding easier, in my opinion. There's nothing wrong with using the default
names, but as your forms become more complex you will find it more difficult
to remember the correct field or control if they have default, generic
names.

SELECT Table2.ModeNo, Table2.ChipSpeed, Table2.Memory
FROM Table2;

Name Combo0
ControlSource Blank
Row Source Select[Table2 Query].ModelNo, [Table2
Query].ChipSpeed, [Table2 Query].Memory From [Table2 Query];
Bound Column 1
Column Count 3
Column Widths 1";0";0"

The Text Box has the following :

Control Source: =cboModelNo.Column(1)

Post the Row Source SQL. If it is a named, query, open the query, then
click View >> SQL. Copy what you see there, and paste it into your
response, along with the query name.

Provide the following information about the combo box:
Name
ControlSource
Row Source
Bound Column
Column Count
Column Widths

Post the Control Source of the text box in which you would have Chip
Speed
appear, and the same for the Memory text box.

I have tried and it seems that I can't get the 2 and 3 column to fill
in. I
followed your instructions and I can't seem to get it to work. I am
using
MS
Access 2003 if that makes a difference...

:

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count
to
3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the
combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1)
is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be
a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that
will
yield satisfactory results, but I won't go into other options unless
there
is a need.

I am creating a Inventory database and I have a model number field a
Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and
memory
information. When I put the model number in its field I want the
other
fields
to be automatically populated with the standard configuration
information.
how do I do that.

 

[JR]

That did the trick, Thanks Bruce....

Since the combo box is named Combo0 the Control Source needs to be:

=Combo0.Column(1)

As a suggestion, meaningful names for combo boxes and other controls make
coding easier, in my opinion. There's nothing wrong with using the default
names, but as your forms become more complex you will find it more difficult
to remember the correct field or control if they have default, generic
names.

SELECT Table2.ModeNo, Table2.ChipSpeed, Table2.Memory
FROM Table2;

Name Combo0
ControlSource Blank
Row Source Select[Table2 Query].ModelNo, [Table2
Query].ChipSpeed, [Table2 Query].Memory From [Table2 Query];
Bound Column 1
Column Count 3
Column Widths 1";0";0"

The Text Box has the following :

Control Source: =cboModelNo.Column(1)

Post the Row Source SQL. If it is a named, query, open the query, then
click View >> SQL. Copy what you see there, and paste it into your
response, along with the query name.

Provide the following information about the combo box:
Name
ControlSource
Row Source
Bound Column
Column Count
Column Widths

Post the Control Source of the text box in which you would have Chip
Speed
appear, and the same for the Memory text box.

I have tried and it seems that I can't get the 2 and 3 column to fill
in. I
followed your instructions and I can't seem to get it to work. I am
using
MS
Access 2003 if that makes a difference...

:

You could make a query with the three fields in this order: ModelNo,
ChipSpeed, Memory. Use the query as the Row Source of a combo box
(cboModelNo). Set the combo box Bound Column to 1, the Column Count
to
3,
and the Column widths to something like:
1.5";0";0"

Set the Control Source of an unbound text box (on the same form as the
combo
box) to:
=[cboNodelNo].Column(1)
For another unbound text box:
=[cboNodelNo].Column(2)

Combo box columns use zero-based numbering in this case, so Column(1)
is
actually the second column (the first column is 0).

Access may put extra brackets in the expression, but that shouldn't be
a
problem.

This is one of several methods you could use. If this method isn't
performing as you would like there is probably another approach that
will
yield satisfactory results, but I won't go into other options unless
there
is a need.

I am creating a Inventory database and I have a model number field a
Chip
Speed field and a Memory Field.

My question is the model Number has a standard Chip speed and
memory
information. When I put the model number in its field I want the
other
fields
to be automatically populated with the standard configuration
information.
how do I do that.