Is there a way to use a form in Access where you enter in information in one box and it will populate options in another box? Example: I have a table that has numbers and descriptions in it - the numbers are tied to the descriptions, but there can be multiple descriptions for one number. I would like to be able to put the number in one box and then choose from the list of descriptions that only go with that number from another box. I am wondering if this is even possible. Thank you for your help.
7 944
Probably, but we will need a bit more information.
Can you post in design view the relevant part of the table, and the corresponding data.
Also, having selected a description, what do you want to do with it?
Phil
This is the only information that is in the table (other than the auto ID field that is created by Access). One field is the number and the other field is the description. I have an entry form that I am using a combo box to pull up the information in now. The information that I select from that combo box (along with other information that is entered on the form) is then put into another table that I pull the search query from. I am trying to see if there is an easier way for me to pull up the descriptions instead of scrolling through them. Hoping that I can enter the number in one "field" on the form and that in the other box (either combo or list) it will populate only the descriptions that go with that number. Then this information that is selected will be saved in the other table (as it is now). Hope that helps to clear it up. Thanks
Sorry, I can not help further.
I asked for specific information, and although you have partially answered what it is used for, the first two questions remain unanswered.
Phil
Well thank you for your time, but I cannot provide the information that you are specifically asking for. I provided the information that I was able to.
NeoPa 32,556
Expert Mod 16PB
Hi Denielle.
I can understand there being issues posting data in public. That's a common problem. Are you sure posting a table design is unacceptable though? That would be very unusual. In fact, if that's the case then I'm not sure why you'd post such a request for help. Without even the table design it would be difficult even to understand the problem properly. Short of a perfectly-expressed question, and like most this is certainly that (Perfectly-expressed questions being extremely rare.), how could anyone be expected to help?
If you find that posting the design is acceptable after all then the data shouldn't be a problem. It may take some time and trouble to prepare some data that is not real but behaves in the way described, but that shouldn't be enough of a problem if you're asking someone to spend their time to help you. Surely?
I admire your tact, Neopa, as usual you're spot on.
Phil
From the way you describe you tables, I think you might benefit by researching and understanding Database Normalization and Table Structures Without this understanding, what you are running into becomes pretty common.
It's also one of the reasons asked for the information that he asked for.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: edworboys |
last post by:
I have designed a data entry form with a number of fields and a sub
form. The first field (Country) is a combo box and the user selects a
country. This, in turn reduces the number of options in the...
|
by: Alex.Wisnoski |
last post by:
I have a data entry form with a combo box to look up an entrant's name.
If the name is already in the table then it pulls up the record and
that part of the form works fine. If the name isn't in...
|
by: Jamie Pittman via AccessMonster.com |
last post by:
I am currently using a form to track employee time to customer and warehouse. I want to be able to take information from one record and post this to tne next record(finish time on the first record...
|
by: filbennett |
last post by:
Hi Everyone,
I'm generally unfamiliar with Access form design, but have programmed
Cold Fusion applications for a couple of years.
I'd like to build a data entry form in Access that allows the...
|
by: Rabbit |
last post by:
Cascading Combo/List Boxes
This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one...
|
by: Rotsey |
last post by:
Hi,
I am loading a tab control on a form.
The code loads textboxes and comboboxes and checkboxes, normal
data entry form that loads a table row of data.
I have a combo on the form above the...
|
by: tolukosi |
last post by:
Guys,
I am working on my school project using Visual Basic to take Customer Record, Staff Record and To Take Drug Record all in a Drug Store. It will be an inventory software that will take order...
|
by: pod |
last post by:
I am new to OOD and n-tier architecture but I want to start the right way.
In Visual Studio, I have created a solution with three projects c/w reference to each other i.e. the Business Logic...
|
by: tzoykas |
last post by:
Hello all
I am trying to create a (simple) database that will hold an inventory of my things, using two tables. One will hold the objects and the other, which object is contained in which.
The...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |