Table with combobox type

[Revned]

hi,

im not sure if this the right category to ask
but can anyone help me to accomplish,

i have a table with a column name [ItemCode]
i set the format to combo box
the reason is i am making this table to be a subform in my main form.

now i want that when i chose any of my item code from [ItemCode]
column it will also display automatically ItemDescription and the Price.

need your help to accomplish on this, i am using access 2003

thanks for any help

 

[Larry Daugherty]

No matter the later intended use, *Don't use Lookup Fields in Tables*.
Visit
www.mvps.org/access for a discussion.

You would be better advised to use a subform than a table datasheet to
display and modify records. That is easily done by designing the Form
that you'll use for the subform to look as much like a single row of
data as possible. Set its properties to display continuous Forms.
You will end up with superior control that way. Also, you can design
in a combobox as one of the controls and end up with something that
looks exactly like what you want. By designing the combobox and its
query and then designing the individual controls on your form you can
control the use of your forms and protect your data.

HTH

 

[Revned]

my main form have many buttons so i can not set to a continouse forms
and I bound my subform in my main form with a table tblItems

my main form with a subform and my subform is bound to that table
with that table on the Item column I set its format to Combo.

please help me on how to accomplish that when I select from my Item column
will also display the Item Description to Item Description column

let say
Item Code Item Description

i just want that the item description will populat as i select item code
from my Item Code column...

thanks again

No matter the later intended use, *Don't use Lookup Fields in Tables*.
Visit
www.mvps.org/access for a discussion.

You would be better advised to use a subform than a table datasheet to
display and modify records. That is easily done by designing the Form
that you'll use for the subform to look as much like a single row of
data as possible. Set its properties to display continuous Forms.
You will end up with superior control that way. Also, you can design
in a combobox as one of the controls and end up with something that
looks exactly like what you want. By designing the combobox and its
query and then designing the individual controls on your form you can
control the use of your forms and protect your data.

HTH
--
-Larry-
--

hi,

im not sure if this the right category to ask
but can anyone help me to accomplish,

i have a table with a column name [ItemCode]
i set the format to combo box
the reason is i am making this table to be a subform in my main form.

now i want that when i chose any of my item code from [ItemCode]
column it will also display automatically ItemDescription and the Price.

need your help to accomplish on this, i am using access 2003

thanks for any help

 

[Jeff Boyce]

It sounds like you've already decide on "how" you'll handle this ("forms
have so many buttons ...").

If you're looking for someone to tell you how to do it your way, you may get
help.

Or if you're looking for help getting something done, consider the
alternative suggestions you can receive here, and offer a bit more
description.

Regards

Jeff Boyce
Microsoft Office/Access MVP

my main form have many buttons so i can not set to a continouse forms
and I bound my subform in my main form with a table tblItems

my main form with a subform and my subform is bound to that table
with that table on the Item column I set its format to Combo.

please help me on how to accomplish that when I select from my Item column
will also display the Item Description to Item Description column

let say
Item Code Item Description

i just want that the item description will populat as i select item code
from my Item Code column...

thanks again

No matter the later intended use, *Don't use Lookup Fields in Tables*.
Visit
www.mvps.org/access for a discussion.

You would be better advised to use a subform than a table datasheet to
display and modify records. That is easily done by designing the Form
that you'll use for the subform to look as much like a single row of
data as possible. Set its properties to display continuous Forms.
You will end up with superior control that way. Also, you can design
in a combobox as one of the controls and end up with something that
looks exactly like what you want. By designing the combobox and its
query and then designing the individual controls on your form you can
control the use of your forms and protect your data.

HTH
--
-Larry-
--

hi,

im not sure if this the right category to ask
but can anyone help me to accomplish,

i have a table with a column name [ItemCode]
i set the format to combo box
the reason is i am making this table to be a subform in my main form.

now i want that when i chose any of my item code from [ItemCode]
column it will also display automatically ItemDescription and the Price.

need your help to accomplish on this, i am using access 2003

thanks for any help

 

[Piet Linden]

It sounds like you've already decide on "how" you'll handle this ("forms
have so many buttons ...").

If you're looking for someone to tell you how to do it your way, you may get
help.

Or if you're looking for help getting something done, consider the
alternative suggestions you can receive here, and offer a bit more
description.

Regards

Jeff Boyce
Microsoft Office/Access MVP

my main form have many buttons so i can not set to a continouse forms
and I bound my subform in my main form with a table tblItems

my main form with a subform and my subform is bound to that table
with that table on the Item column I set its format to Combo.

please help me on how to accomplish that when I select from my Item column
will also display the Item Description to Item Description column

let say
Item Code        Item Description

i just want that the item description will populat as i select item code
from my Item Code column...

thanks again

No matter the later intended use, *Don't use Lookup Fields in Tables*.
Visit
   www.mvps.org/access for a discussion.
You would be better advised to use a subform than a table datasheet to
display and modify records.  That is easily done by designing the Form
that you'll use for the subform to look as much like a single row of
data as possible.  Set its properties to display continuous Forms.
You will end up with superior control that way.  Also, you can design
in a combobox as one of the controls and end up with something that
looks exactly like what you want.  By designing the combobox and its
query and then designing the individual controls on your form you can
control the use of your forms and protect your data.
HTH
--
-Larry-
--
hi,
im not sure if this the right category to ask
but can anyone help me to accomplish,
i have a table with a column name [ItemCode]
i set the format to combo box
the reason is i am making this table to be a subform in my main
form.
now i want that when i chose any of my item code from [ItemCode]
column it will also display automatically ItemDescription and the
Price.
need your help to accomplish on this, i am using access 2003
thanks for any help

And keep in mind that most people who have been forced into contact
with lookups in tables vehemently detest them.... I just find that
they confuse things later on. What you *see* with lookup columns is
absolutely NOT what you get. That's why many people suggest doing it
the "hard" way - it doesn't screw up your queries etc. Sure, you have
to join tables, but that's Database 101 stuff.