I have a table named AssignedTo. In this table are the fields: AssignedTo_ID, Department, Employee.
On my form, I need to create 2 combo boxes. The first one will select the department. Based one what department is selected, the second combo box will be populated with employees in that department.
Can someone help me on how to do this?
3 1340
I am also need solution to the same problem!!!! mine is however a list( two lists rather)
NeoPa 32,566
Recognized Expert Moderator MVP
Saratee,
This is not your thread, so please don't hijack it. Feel free to read it and get any info from it that is helpful. However, if YOU have a question, please post it in a separate thread.
Administrator.
@Irw0831, I think we can manage this. Give me a while for a little thought.
NeoPa 32,566
Recognized Expert Moderator MVP
Right, the first step is to have a read through Example Filtering on a Form.
It may well be that this is all you need. Certainly all the points are covered (although the example isn't exactly your scenario).
If, after reading this, you need more help, just let us know.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: mr_burns |
last post by:
hi,
is it possible to change the contents of a combo box when the contents
of another are changed. for example, if i had a combo box called
garments containing shirts, trousers and hats, when the user selects
shirts another combo box called 'size' would contain sizes in relation
to shirts (ie. chest/neck size). the same would occur for trousers and
hats. when the user selects an option in the garment combo box, the
options available...
|
by: OhFiddleSticks |
last post by:
Does anyone know if there is a way to add a text value to a combo box (the
text box part, not the rowsource) in VBA without triggering an update
event? I've tried everything I can think of without success.
What I want is a combo box that I set the rowsource for in VBA and requery
it, then it drops down, and enters a probable selection that may or may
not already be in the list to the text box portion. Then I can manually
compare the...
|
by: Maria Joao |
last post by:
I have two synchronized combo boxes and after the selection of the
desired record, I need the user to open the related report, by
pressing a button.
My problem is that a combo box doesn't update do the first one. The
record are correct, but the first one is always from the last
selection. How can I update the second combo box?
Thanks
|
by: BigJay |
last post by:
I am 1. trying to have a combobox used as a selector to display records
in a subform. and not sure on how to get selected info into subform.the
combo is populated but can not get subform updated when selection is
made.....
2. I also want to use one combo box to select a second set of
criteria in a second combo box that is then used to refine displayrd
records in a a subform.... am afraid im lost on this..???
I have a main table that...
|
by: Torilyn73 |
last post by:
I posted this earlier... or thought I did... anyway.. it's doesn't
appear in the list so I'm reposting it.
Can someone please explain to me how to set up the lostfocus event
for a combo box. I need the combo to return to its default value when
the user clicks away from it ... either somewhere on the form itself
or another app. I have no clue how to do this and would really
appreciate some help.
Thanks!
| |
by: bloukopkoggelmander |
last post by:
Hi all
Now this seems staright forward, but I am having loads of problems getting this to work.
What I want to do is to have two combo boxes . The user makes a selection in the top one and then only data relavant to the selection is then displayed in the combo box below where the user can make another choise.
For instance :
I have one table - VehicleMakeAndModel
|
by: didihynes |
last post by:
Hi Guys,
I'm in desparate need of help. I am producing a database for my dissertation and have got majorly stuck. I am currently creating a form in which the user will select a student from a combo box, which that selection populates the next combo for the course selection. I have managed to do that with the coding shown below, my next combo will work from the course selection to bring back the feedback topics associated with that course,...
|
by: kcdoell |
last post by:
I have 5 cascading combo boxes on a form. Below is a sample of my vb in the first combo box:
Private Sub CboDivision_AfterUpdate()
'When the Division is selected, the appropriate Segment list will
'display in the drop down list of CboSegment
With Me!
If IsNull(Me!cboDivision) Then
|
by: dudeja.rajat |
last post by:
On Sat, Aug 30, 2008 at 2:32 PM, Fredrik Lundh <fredrik@pythonware.comwrote:
Fredrik, Thanks so much. That worked.
Following this, I can now see that my combo2 has no previous elements
and contains only the elements relevant to selection in combo1.
Now, as soon as I select something in combo 2 and go back to change
selection in combo1 the combo2 must get its history cleared up (i.e
the previous selection in combo2's entry subwidget)
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |