473,434 Members | 1,791 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,434 software developers and data experts.

Drop Data from a Combo Box on a FORM into a Report

Hi ,

I am having a Form that has 2 combo Boxes . The first one consists of particular Dates and Second one is the School Name. So when the user selects the Particular School the related data gets filtered from a master table and gets dumped into the Report Table. So here on the Report i Need this Particular date also to come and appear based on the selection they make on the combo box.This Date is not there in the Report table.It is only present on the form in the combo box. So is there any way that i can get this date to appear on the Report.

Please help...
Thanks
Jason..
Jan 15 '08 #1
5 1308
Rabbit
12,516 Expert Mod 8TB
Forms!FormName!ControlName
Jan 15 '08 #2
Forms!FormName!ControlName
Hi sir,

I have taken a text Box and in the Control source...i have put the line that u sent as Forms!frmFormStudent!cboPlanYear ...But it was not accepting it and was giving an error saying there is no field list available with this name....

I also have some data coming from the table into this report as i have mentioned earlier.....Its only the date i want to get from this combo box on the Form.....
Jan 15 '08 #3
Rabbit
12,516 Expert Mod 8TB
To set a control source to something other than a field, you need to put = in front of the expression.

To retrieve a value from an object, that object needs to be open, so the form will have to stay open when the report is created.
Jan 15 '08 #4
To set a control source to something other than a field, you need to put = in front of the expression.

To retrieve a value from an object, that object needs to be open, so the form will have to stay open when the report is created.
Thank you ....Very Much sir....
That works fine for me......

I learnt a new thing today......

Thanks again...
Jason..
Jan 15 '08 #5
Rabbit
12,516 Expert Mod 8TB
Not a problem, good luck.
Jan 15 '08 #6

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

Similar topics

1
by: Jon | last post by:
I am trying to create a "front end program" to an oracle database and am using visual basic .net to create the program that will accomplish this. What i need to do and what i can't find is the code...
4
by: CSDunn | last post by:
Hello, I have a combo box (Combo7) that needs to call a function during the After Update event of the combo box. The function resides in an Access 2000 ADP Module called MMAnswerData_code. The...
0
by: Dec | last post by:
Ok to simplify things I'll just give an example. This is pretty much what I want to do (minus the postcode): http://www.perrys.co.uk/usedcar?ID=F5J9BNNBMVK00DF I have relatively little...
1
by: Dec | last post by:
Ok to simplify things I'll just give an example. This is pretty much what I want to do (minus the postcode): http://www.perrys.co.uk/usedcar?ID=F5J9BNNBMVK00DF I have relatively little...
1
by: Donna Sabol | last post by:
I have a form (frm_MAIN_RPT) that contains a combo box (Combo6) & subform (dbo_REQ_subform). The combo box is used to select the "cost center" data that will be displayed in the subform. From...
12
by: Nhmiller | last post by:
When I start to type the data for a new record, I would like a dropdown box to open next to it from which I can choose the data from a previously entered record that starts with the same letter....
4
by: Miguel | last post by:
I have synchronized combo boxes linking Account Type with Customer Names based on the template that Microsoft has in one of its samples databases. There are the appropriate relationships between...
2
by: eimbert | last post by:
I have designed a report named report by Recruiter. I have made a form called frmRecruitmentReports, on this form I have created a pair of combo boxes . 1.Beggining Date (both are unbound)...
30
ADezii
by: ADezii | last post by:
This week’s Tip of the Week will clearly demonstrate how you can dynamically set the Drop Down List Width of a Combo Box to the length of the longest item in its Row Source. The inspiration for this...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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
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,...
0
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
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.