Using Combo Box in more then one field

[Ravi Verma]

Hi,

I am trying to use combo box in three fields of a table. but i am not being
able to do that in more then one field. I am a new user of access 2000, i am
doing it by following the following website:
http://www.bcschools.net/staff/AccessHelp.htm
Table Name: DailyExpenses
Field Name
DE_ID AutoNumber
Date Date/Time
Heads Text (Combo Box: Value List: Bus Fare,Rikshaw Fare,Auto
Fare,Phone,Others)
Amount Currency
Purpose Memo
Incharge Text(Combo Box: Value List: Ravi,Kangkan,Anjanil,Others)
Status Text(Combo Box: Value List: Paid,Unpaid,Others)

I have got the desired drop down menu in "Heads" field only, but in
"Incharge" and "Status" fields, when the click the arow only a single blank
menu drops without any data.

Regards,
Ravi Verma

 

[Tom Wickerath]

Hi Ravi,

I generally discourage the use of value list based combo boxes, because one
must open the object (table, form, etc.) in design view in order to add or
remove items from the list. In addition, the items are not sorted
alphabetically; they are displayed in the order entered.

If you send me a compacted--and preferably zipped--copy of your database, I
will take a look at it for you. If you are interested, send me a private
e-mail message with a valid reply-to address. My e-mail address is available
at the bottom of the contributor's page indicated below.

Please do not post your e-mail address (or mine) to a newsgroup reply. Doing
so will only attract the unwanted attention of spammers.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Larry Daugherty]

If you are using Lookup Fields, Don't! They will lead you to troubles
sooner or later. Stick with simple, atomic, datatypes.

Some useful resources:

microsoft.public.access.gettingstarted
microsoft.public.access.tablesdesign

www.mvps.org/access

Welcome to Access

HTH

 

[Ravi Verma]

Thanks very but both of you. I will zip the database and send it to Tom
Wickerath's private email id.

Regards,
Ravi Verma

 

[Tom Wickerath]

Hi Ravi,

Got it. In this case, you needed to specify "Value List" for the row source
type, and enter the desired values into the Row Source. So, for example:

Change this:
Row Source Type Paid,Unpaid,Others
Row Source

to this:
Row Source Type Value List
Row Source Paid;Unpaid;Others

Note: Commas are used to separate columns, when the column count is > 1. In
this case, Access will change the commas to semicolons for you, since your
column count is 1.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________