Table with combobox type

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

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-
--

"Revned" wrote in message
...
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

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

"Larry Daugherty" wrote:

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-
--

"Revned" wrote in message
...
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

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

"Revned" wrote in message
...
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

"Larry Daugherty" wrote:

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-
--

"Revned" wrote in message
...
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

On Jul 20, 9:52*am, "Jeff Boyce" wrote:
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

"Revned" wrote in message

...

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

"Larry Daugherty" wrote:

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-
--

"Revned" wrote in message
...
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.