ACCESS COMBO BOX

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i setup 2 Table, Table 1 & Table 2 under Tables
Table 1 : Name
Quantity

Table 2 : Item No
Item Name
Price
Amount

Under Forms setup Table 1

Table 1 : Name
Item No (Combo Box)
Item Name
Price
Quantity
Amount (Price * Quanty)

use item no (dropdown) to select item no than i would like to see Item Name,
Price. Quantity will be key-in than to be appear Amount.

Pls help me to advise

Thanks

JOHN
 
You can do this a few different ways. This is the way we chose to do so:

In the form rename the Item No to cboItemNo. The control source for Item
name should become "=cboItemNo.Column(3) (note: the column number will be
whichever column in the combo box you want data to be pulled from. The first
column is 0 instead of 1. To find out what column you want look at the lookup
query for your combo box which is found in the design view of the transaction
table; click on Item No ->Lookup ->Row Source ->'...'). This will be the same
for Price just a different column number. Good luck!
 
Hi Maria

I try to follow your advice and click combo box and come out the following
massage

can't be edited; it's bound to expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN
 
It sounds like the cbo code is in the wrong text box. The expression should
go in the box you want automatically populated. your combo box (I presume
Item No.) should still have the control source as [Item No] and should be
named 'cboItemNo'. In the text box 'Item Name' you should have whatever you
want the text box named and in control source '=cboItemNo.Column(3)'.
 
Hi Maria

I manage get the text box auto appear. But another problem is I use Form to
key Item No & Item Name (which appear automatic), but Item No is updated in
Table, itemname is not updated in table. Once I use report to print, Item
Name is "BLANK". Pls advice also.

Thanks

JOHN

Maria said:
It sounds like the cbo code is in the wrong text box. The expression should
go in the box you want automatically populated. your combo box (I presume
Item No.) should still have the control source as [Item No] and should be
named 'cboItemNo'. In the text box 'Item Name' you should have whatever you
want the text box named and in control source '=cboItemNo.Column(3)'.
John said:
Hi Maria

I try to follow your advice and click combo box and come out the following
massage

can't be edited; it's bound to expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN
Click to expand...
Click to expand...
 
You should not store redundant data (except for transactional data - ie the
price at a givven moment in time)
Use a query linking the tables as a recordsource for the report

Pieter


John said:
Hi Maria

I manage get the text box auto appear. But another problem is I use Form
to
key Item No & Item Name (which appear automatic), but Item No is updated
in
Table, itemname is not updated in table. Once I use report to print, Item
Name is "BLANK". Pls advice also.

Thanks

JOHN

Maria said:
It sounds like the cbo code is in the wrong text box. The expression
should
go in the box you want automatically populated. your combo box (I presume
Item No.) should still have the control source as [Item No] and should be
named 'cboItemNo'. In the text box 'Item Name' you should have whatever
you
want the text box named and in control source '=cboItemNo.Column(3)'.
John said:
Hi Maria

I try to follow your advice and click combo box and come out the
following
massage

can't be edited; it's bound to
expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN

:

You can do this a few different ways. This is the way we chose to do
so:

In the form rename the Item No to cboItemNo. The control source for
Item
name should become "=cboItemNo.Column(3) (note: the column number
will be
whichever column in the combo box you want data to be pulled from.
The first
column is 0 instead of 1. To find out what column you want look at
the lookup
query for your combo box which is found in the design view of the
transaction
table; click on Item No ->Lookup ->Row Source ->'...'). This will be
the same
for Price just a different column number. Good luck!

:

i setup 2 Table, Table 1 & Table 2 under Tables
Table 1 : Name
Quantity

Table 2 : Item No
Item Name
Price
Amount

Under Forms setup Table 1

Table 1 : Name
Item No (Combo Box)
Item Name
Price
Quantity
Amount (Price * Quanty)

use item no (dropdown) to select item no than i would like to see
Item Name,
Price. Quantity will be key-in than to be appear Amount.

Pls help me to advise

Thanks

JOHN
Click to expand...
Click to expand...
Click to expand...



--
 
Hi Pieter

How to link with query

Pls advise me.

Thanks
JOHN

Pieter Wijnen said:
You should not store redundant data (except for transactional data - ie the
price at a givven moment in time)
Use a query linking the tables as a recordsource for the report

Pieter


John said:
Hi Maria

I manage get the text box auto appear. But another problem is I use Form
to
key Item No & Item Name (which appear automatic), but Item No is updated
in
Table, itemname is not updated in table. Once I use report to print, Item
Name is "BLANK". Pls advice also.

Thanks

JOHN

Maria said:
It sounds like the cbo code is in the wrong text box. The expression
should
go in the box you want automatically populated. your combo box (I presume
Item No.) should still have the control source as [Item No] and should be
named 'cboItemNo'. In the text box 'Item Name' you should have whatever
you
want the text box named and in control source '=cboItemNo.Column(3)'.
:

Hi Maria

I try to follow your advice and click combo box and come out the
following
massage

can't be edited; it's bound to
expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN

:

You can do this a few different ways. This is the way we chose to do
so:

In the form rename the Item No to cboItemNo. The control source for
Item
name should become "=cboItemNo.Column(3) (note: the column number
will be
whichever column in the combo box you want data to be pulled from.
The first
column is 0 instead of 1. To find out what column you want look at
the lookup
query for your combo box which is found in the design view of the
transaction
table; click on Item No ->Lookup ->Row Source ->'...'). This will be
the same
for Price just a different column number. Good luck!

:

i setup 2 Table, Table 1 & Table 2 under Tables
Table 1 : Name
Quantity

Table 2 : Item No
Item Name
Price
Amount

Under Forms setup Table 1

Table 1 : Name
Item No (Combo Box)
Item Name
Price
Quantity
Amount (Price * Quanty)

use item no (dropdown) to select item no than i would like to see
Item Name,
Price. Quantity will be key-in than to be appear Amount.

Pls help me to advise

Thanks

JOHN
Click to expand...
Click to expand...



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Click to expand...
 
okido
create a query (queries/new)
add your tables
hit close
if your relationships are set up it should "automagically" join your tables
else make join by dragging the master join field to the child join field,
extranous joins might be deleted by selectiong the join -> right click ->
delete
drag the fields from your tables down to the grid
Pieter

I would strongly suggest that you buy a book like 'MS Access for dummies' to
get the basics though, as most of the people answering questions in this
newsgroup are professionals using their expertice to guide people who has
made an effort themselves to solve a spesific problem. I & others will
however be around to "break the ice" - but we're not around to grant free
education in 'how to master MS Access' - great book title BTW <g>

John said:
Hi Pieter

How to link with query

Pls advise me.

Thanks
JOHN

Pieter Wijnen said:
You should not store redundant data (except for transactional data - ie
the
price at a givven moment in time)
Use a query linking the tables as a recordsource for the report

Pieter


John said:
Hi Maria

I manage get the text box auto appear. But another problem is I use
Form
to
key Item No & Item Name (which appear automatic), but Item No is
updated
in
Table, itemname is not updated in table. Once I use report to print,
Item
Name is "BLANK". Pls advice also.

Thanks

JOHN

:

It sounds like the cbo code is in the wrong text box. The expression
should
go in the box you want automatically populated. your combo box (I
presume
Item No.) should still have the control source as [Item No] and should
be
named 'cboItemNo'. In the text box 'Item Name' you should have
whatever
you
want the text box named and in control source '=cboItemNo.Column(3)'.
:

Hi Maria

I try to follow your advice and click combo box and come out the
following
massage

can't be edited; it's bound to
expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN

:

You can do this a few different ways. This is the way we chose to
do
so:

In the form rename the Item No to cboItemNo. The control source
for
Item
name should become "=cboItemNo.Column(3) (note: the column number
will be
whichever column in the combo box you want data to be pulled from.
The first
column is 0 instead of 1. To find out what column you want look at
the lookup
query for your combo box which is found in the design view of the
transaction
table; click on Item No ->Lookup ->Row Source ->'...'). This will
be
the same
for Price just a different column number. Good luck!

:

i setup 2 Table, Table 1 & Table 2 under Tables
Table 1 : Name
Quantity

Table 2 : Item No
Item Name
Price
Amount

Under Forms setup Table 1

Table 1 : Name
Item No (Combo Box)
Item Name
Price
Quantity
Amount (Price * Quanty)

use item no (dropdown) to select item no than i would like to
see
Item Name,
Price. Quantity will be key-in than to be appear Amount.

Pls help me to advise

Thanks

JOHN
Click to expand...



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Click to expand...
Click to expand...
 
okido
create a query (queries/new)
add your tables
hit close
if your relationships are set up it should "automagically" join your tables
else make join by dragging the master join field to the child join field,
extranous joins might be deleted by selectiong the join -> right click ->
delete
drag the fields from your tables down to the grid
Pieter

I would strongly suggest that you buy a book like 'MS Access for dummies' to
get the basics though, as most of the people answering questions in this
newsgroup are professionals using their expertice to guide people who has
made an effort themselves to solve a spesific problem. I & others will
however be around to "break the ice" - but we're not around to grant free
education in 'how to master MS Access' - great book title BTW <g>

John said:
Hi Pieter

How to link with query

Pls advise me.

Thanks
JOHN

Pieter Wijnen said:
You should not store redundant data (except for transactional data - ie
the
price at a givven moment in time)
Use a query linking the tables as a recordsource for the report

Pieter


John said:
Hi Maria

I manage get the text box auto appear. But another problem is I use
Form
to
key Item No & Item Name (which appear automatic), but Item No is
updated
in
Table, itemname is not updated in table. Once I use report to print,
Item
Name is "BLANK". Pls advice also.

Thanks

JOHN

:

It sounds like the cbo code is in the wrong text box. The expression
should
go in the box you want automatically populated. your combo box (I
presume
Item No.) should still have the control source as [Item No] and should
be
named 'cboItemNo'. In the text box 'Item Name' you should have
whatever
you
want the text box named and in control source '=cboItemNo.Column(3)'.
:

Hi Maria

I try to follow your advice and click combo box and come out the
following
massage

can't be edited; it's bound to
expression'cobItemNo.Column(3).'

Pls help me solve.

Thanks

JOHN

:

You can do this a few different ways. This is the way we chose to
do
so:

In the form rename the Item No to cboItemNo. The control source
for
Item
name should become "=cboItemNo.Column(3) (note: the column number
will be
whichever column in the combo box you want data to be pulled from.
The first
column is 0 instead of 1. To find out what column you want look at
the lookup
query for your combo box which is found in the design view of the
transaction
table; click on Item No ->Lookup ->Row Source ->'...'). This will
be
the same
for Price just a different column number. Good luck!

:

i setup 2 Table, Table 1 & Table 2 under Tables
Table 1 : Name
Quantity

Table 2 : Item No
Item Name
Price
Amount

Under Forms setup Table 1

Table 1 : Name
Item No (Combo Box)
Item Name
Price
Quantity
Amount (Price * Quanty)

use item no (dropdown) to select item no than i would like to
see
Item Name,
Price. Quantity will be key-in than to be appear Amount.

Pls help me to advise

Thanks

JOHN
Click to expand...



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Click to expand...
Click to expand...



--
 
Hi

Thank you for your advice, I am not using for quite some time, that is why i
forgotten, previous use many. I will try to pick-up the basic. Anyway thank
you so much.

JOHN
 
Back
Top