General Help with Set-up

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

I am looking for any help that I can get with this more
than likely simple problem.

I have a database for a sign inventory that I am putting
together. Each entry will have a sign code and each code
a description. I want to be able to enter the sign code
and have the description pop up automatically or vice-
versa. Any ideas on how to accomplish this.

Thanks.

Mike H.
 
I am looking for any help that I can get with this more
than likely simple problem.

I have a database for a sign inventory that I am putting
together. Each entry will have a sign code and each code
a description. I want to be able to enter the sign code
and have the description pop up automatically or vice-
versa. Any ideas on how to accomplish this.
Click to expand...

One simple way would be to have a Combo Box on the Form where you're
entering your data (and yes, DO use a Form, not a table datasheet).

Have a Combo Box based on the table of codes, with SignCode as the
bound column and including the description. Put a textbox on the form
with a Control Source of

=comboboxname.Column(1)

The Column property is zero based so this will display the description
associated with the selected code.

If you're proposing to store the code and the description in a second
table... don't; just store the code and use a query or a combo box to
display the description.
 
-----Original Message-----


One simple way would be to have a Combo Box on the Form where you're
entering your data (and yes, DO use a Form, not a table datasheet).

Have a Combo Box based on the table of codes, with SignCode as the
bound column and including the description. Put a textbox on the form
with a Control Source of

=comboboxname.Column(1)

The Column property is zero based so this will display the description
associated with the selected code.

If you're proposing to store the code and the description in a second
table... don't; just store the code and use a query or a combo box to
display the description.


.
Click to expand...

Thanks for the information.

I have a table with column 1 being the code and column 2
being the description.

I have form with the code combo box, showing both the
code/description columns in the pull down. I also have a
description text box that I want the description to pop
into when I choose the code.

My combo box is cmbNewSignCode.

For the description text box, I put =cmbNewSignCode.Column
(1) and it displays a #Name? on my form view in this
field.

Any additional help you can provide would be appreciated.

Thanks.

Mike
 
I have a table with column 1 being the code and column 2
being the description.

I have form with the code combo box, showing both the
code/description columns in the pull down. I also have a
description text box that I want the description to pop
into when I choose the code.

My combo box is cmbNewSignCode.

For the description text box, I put =cmbNewSignCode.Column
(1) and it displays a #Name? on my form view in this
field.

Any additional help you can provide would be appreciated.
Click to expand...

Make sure that the RowSource for cmbNewSignCode is either the code
table or (better) a Query selecting the two fields in that table,
sorted appropriately; and that the RowCount property of the combo is
2.
 
Back
Top