473,511 Members | 15,046 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Dynamic MS Access Lookup Field

2 New Member
I would like to know if it is possible to limit the records in a lookup list (bound to a child form) only to a relationshiped index of an active parent.

For example I have a list of people contacts from various organisations. Each organisation is purchasing certain services and I want to allocate a specific contact to each service nomination. The active form presents all the options for one organisation.

The best I can achieve in a look up list - is a list of all contacts for all organisations. Ideally a look up list offering only the contacts for the focus organisation would be great.

If there are any examples out there that I can be referred to, or any advice to resolve this headache - any help would be amazing.
Apr 27 '07 #1
3 3764
MMcCarthy
14,534 Recognized Expert Moderator MVP
Check out this tutorial.

Cascading Combo/List BoxesYou should be able to adapt it to suit your needs. Any questions just ask.

Mary
Apr 27 '07 #2
philby
2 New Member
Check out this tutorial.

Cascading Combo/List BoxesYou should be able to adapt it to suit your needs. Any questions just ask.

Mary
Hi Mary - thanks you a quick and clear response - will take a look and get back to you if needed - again... with thanks.
Apr 27 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi Mary - thanks you a quick and clear response - will take a look and get back to you if needed - again... with thanks.
You're welcome
Apr 27 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

8
20310
by: Vladimir | last post by:
Hello, I have a table in MS Access database. It has one field (with BYTE datatype) that has several properties set in Lookup tab of table Design View. Display Control = Combo Box. Row Source...
30
3092
by: Andante.in.Blue | last post by:
I just browsed through some of my Access links when I came across the Ten Commandments of Access (http://www.mvps.org/access/tencommandments.htm). Some of the points I heartily agree with (and...
1
17632
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
0
2429
by: Michael | last post by:
Hi All, I have a general question. I'm in the process of designing a app that will allow user to enter data for Medical forms and print the corresponding word doc. I have about 100 forms I have to...
6
1778
by: Tim K. | last post by:
Howdy, I'm looking for only a few hints - I need to figure as much of this out on my own as possible so I'll learn it. I'm doing a field study on a mosquito impoundment on some mangrove islands...
8
2235
by: Sandy Pittendrigh | last post by:
I have a how-to-do-it manual like site, related to fishing. I want to add a new interactive question/comment feature to each instructional page on the site. I want (registered) users to be able...
2
1863
by: JHNielson | last post by:
I am trying to see is there is a way to lookup and update a field based on matching part of the contents of a field to a lookup table. Example. I have an "Error Description" field. And it adds...
4
1548
by: seryozha | last post by:
Hello, I'm wonder if a relational database is what i need based on the data i will be entering. Our company will have the following data entered: Customer Part Press Date Operation
1
6772
by: scubasteve | last post by:
Looking up values from an Access table is simple. Simulating the 'Range Lookup' functionality from Excel's VLookup formula is a bit trickier. For those that aren't familiar with this, it allows...
4
4370
by: netnewbie78 | last post by:
Hello All, I don't have a problem (but maybe I will after I explain). I have a question with regards to something I saw in Access 2007. But first, a little backstory: I'm writing a very small...
0
7137
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...
1
7074
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...
0
7506
tracyyun
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...
0
5659
agi2029
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,...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3210
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
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 ...
1
780
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
445
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.