•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 401,458 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,077 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 1342 | Replies: 1
 |
•
•
Join Date: Apr 2008
Posts: 18
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
1) open the table in desihn view.
2)Select the filed u want to alter.
3)Select LOOKUP tab.
4)In display control box,Select Combobox 0r listbox.
5)Under Row Sorce TYpe,SElect Value list.
I want to ask that if I select Combobox,Then in Row Source type we select Value List.
I want to ask that if I select LIstbox,Then in Row Source type we have to select ----????
Under RowSorec ,enter the Values.
Second thing,When we select a combobox we can also write the values that are not in Combobox because Comboboc combines the features of ListBox & Textbox.
When I select Listbox,It also allows me to enyet the new values in a table that are not in Listbox,But Listbox doesn't allow you to type new values.
PLz checj my above procedure for listbox & reply where I m going Wrong.
2)Select the filed u want to alter.
3)Select LOOKUP tab.
4)In display control box,Select Combobox 0r listbox.
5)Under Row Sorce TYpe,SElect Value list.
I want to ask that if I select Combobox,Then in Row Source type we select Value List.
I want to ask that if I select LIstbox,Then in Row Source type we have to select ----????
Under RowSorec ,enter the Values.
Second thing,When we select a combobox we can also write the values that are not in Combobox because Comboboc combines the features of ListBox & Textbox.
When I select Listbox,It also allows me to enyet the new values in a table that are not in Listbox,But Listbox doesn't allow you to type new values.
PLz checj my above procedure for listbox & reply where I m going Wrong.
•
•
Join Date: Jan 2008
Posts: 28
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
•
•
•
•
Originally Posted by mansi sharma 
PLz checj my above procedure for listbox & reply where I m going Wrong.
The very first thing you are doing wrong is using LOOKUPS at the table level. Wrong, wrong, wrong, wrong, wrong....Can you tell I think it's wrong?
See here for more info about that:
The Evils of Lookup Fields at Table Level
It's okay to do lookups at FORM level, but you really should avoid lookups at the table level. It will only cause you pain and suffering later.
Bob Larson
____________________________________
Access MVP
Administrator, Access World Forums
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
____________________________________
Access MVP
Administrator, Access World Forums
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Populating Multiple Text Fields Based On A Dynamic Drop-Down List Selection (PHP)
- Hi guys please clear my doubt. (ASP.NET)
- Deleting an item from a database by selecting it from a drop-down menu (PHP)
- dropdownlist not firing (VB.NET)
- PHP Form Validation ??? (PHP)
- Set Accessibility Features for People Who are Blind or Who Have Low Vision in WinXP (Windows tips 'n' tweaks)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Query database
- Next Thread: EPOS
