473,804 Members | 3,182 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Showing records in a forms from selected record in a pop-up form

5 New Member
Hi All,

I have created a form and subform ( Assignee Outstanding Form ) to display records and related notes in a Helpdesk database table by the assignees respectively. Now, instead of clicking through hundreds of records by assignees in alphabetical order, I would like to use a pop-up form to be opened when the Assignee Outstanding Form is loaded - of which the data come from a query, so the records displayed in the Assignee Outstanding Form ( from the data source query ) are now the ones I selected from the pop-up form.

I have already created this pop-up form by running a query to select the distinct assignees from the Helpdesk database table. How do I put all these together in the Assignee Outstanding Form so the selected assignee is passed on to the query and shows the selected assignee records ?

Your help will be much appreciated. Thanks.

RLau
Feb 13 '07 #1
1 1880
NeoPa
32,579 Recognized Expert Moderator MVP
Let me know if this Tutorial (Example Filtering on a Form.) helps you with your situation?
Feb 13 '07 #2

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

Similar topics

10
10991
by: george | last post by:
Can anyone help? I query a database and return a result on the column "reference". There might be 7 listings. Each row is displayed in a table, with links through to a detail page. I am working on having a "previous" record and a "next" record link on the detail page. This code below works, for the "next" record, by searching the values in the array $myarray for the variable $ref. It then returns the key value and the key value, as a...
5
4391
by: Mike | last post by:
Hi I've written a module to find the first occurrence of a record in a query (that is my forms datasource) that matches four specified criteria. No matter what I try it doesn't seem to find records even though they are in the recordset as you can navigate to them using the forms navigation buttons. weekending, weekday, ba (business area), projected Here's the module can anyone spot where i'm going wrong? Any suggestions would be...
2
1491
by: MLH | last post by:
I feel pretty lucky on my last SQL question. I think I'll try one more... If there is a table (tblCorrespondence) with a field in it named and I am extracting a dynaset of records having an value of "06"... - Lets say the query displays , , and . And lets say that for every record in the table having an value of "06", I would also like to know if there
1
1258
by: Ed West | last post by:
Hello What is the proper way in ASP.Net to not show large parts of the page? For example, if I was showing a record detail page, if the record id does not exist or they don't have rights to see it, I would just show an error message and NOT show the rest of the html for the all the fields in the record. And if possible still be able to use the designer to place the labels and data, etc. In ASP I would do something like: <%
1
1741
by: syedrafey | last post by:
Hello, One of datagrid on my aspx page is not showing records on production server while there are records in database table. I have tested that page on my local machine and it is working fine. All other forms (approx 40+) are working fine on production server. That RuleDetail.aspx page has two user controls. The first user control has a button. When I click button a C# event (delegate) is called which calls a public method in second...
1
3890
by: news.sbcglobal.net | last post by:
Hi! I am able to add records to my SQL 2005 database using bound forms in my Access application, but if I try to edit any records (not only the new records I create) using the same bound forms, I receive a write conflict. For the record, I am currently the only user of this application and my SQL Server database has only one userID. I used this userID to create all of the objects in the database and to connect to the database from...
2
1892
by: RobinDiederen | last post by:
Hi, For a set of records, which I get by doing a SELECT on a database, I want to some computations. After doing those computations, I want data, based on those computations to be stored in another table in the database. I just can't figure out how to do this. For example: 1. do the select (like selecting all male employees from the database) 2. insert those records into another table, with, if their date of birth is between 1/1/1970 and...
3
4253
by: Phillip B Oldham | last post by:
Hi. I'm stretching my boundaries in programming with a little python shell-script which is going to loop through a list of domain names, grab the whois record, parse it, and put the results into a csv. I've got the results coming back fine, but since I have *no* experience with python I'm wondering what would be the preferred "pythonic" way of parsing the whois string into a csv record. Tips/thoughts/examples more than welcome!
4
8937
by: Blackwater | last post by:
There's an old database system called "PICK" - still in use in various forms such as 'OpenQM' - wherein you can SELECT or READ directly into an array variable. For example : "SELECT * FROM DemoTable TO ArrayVar" - stuffs ArrayVar with every record in DemoTable in a format : ArrayVar ArrayVar
6
4159
by: Gun Slinger | last post by:
Hi guys, I have a quick question which i have pondered for a little while. I'm not sure if its even a good idea (so maybe advice on whether or not to do it would be helpful as well). I want to have my first datagridview to have a multi-select (which i have currently), but what i want to happen when multiple rows are selected is different. I have a sub datagridview which is using a relationship in a dataset which allows the two...
0
10569
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10325
jinu1996
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...
1
10315
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,...
0
9140
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, 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...
1
7615
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5519
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...
0
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3815
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2990
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 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...

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.