473,320 Members | 1,846 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,320 software developers and data experts.

how to display one to one relation data on a form.


Hi all,
I have a form which is used to enter workorder details. Now for the service
types I have a one to one relationship with the different services
available. Each Work order detail may have many services (of differnt types
with differnt field values). I need the WorkOrderDetails form to display a
combo from which the user can select the service type and based on this
selection show the appropriate form (eg: frmPlumbing when service type is
plumbing, frmengineering when service=engineering, frmcooking when
service=cooking). Please help.
TIA

--
Regards,
B
Nov 13 '05 #1
2 1119
http://www.mvps.org/access/forms/frm0028.htm

The subject is REALLY misleading. Either that, or you're very lost...
hope this helps.

Nov 13 '05 #2
Use the AfterUpdate Event of the ComboBox and some canny object naming:

Dim strReportName As String

strReportName = Me.cmbServiceType
strReportName = "frm" & strReportName

DoCmd.OpenForm strReportName
Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
"Burghew" <bu*****@mailinator.com> wrote in message
news:cp*********@news-dxb.emirates.net.ae...

Hi all,
I have a form which is used to enter workorder details. Now for the
service
types I have a one to one relationship with the different services
available. Each Work order detail may have many services (of differnt
types
with differnt field values). I need the WorkOrderDetails form to display a
combo from which the user can select the service type and based on this
selection show the appropriate form (eg: frmPlumbing when service type is
plumbing, frmengineering when service=engineering, frmcooking when
service=cooking). Please help.
TIA

--
Regards,
B

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: dmiller23462 | last post by:
Hi guys....I have absolutely NO IDEA what I'm doing with Javascript but my end result is I need two text boxes to stay hidden until a particular option is selected....I've cobbled together the...
7
by: Stefan Finzel | last post by:
Hi, is there a way to change the display property on Windows Mobile 2003 SE Mobile/Pocket Internet Explorer? See following example. Please note: visibilty property has the same problem. Is...
4
by: Joe Van Meer | last post by:
Hi, Is the datalist meant for one table or can I use it to display information from 2 different tables? Or should I be looking at a datagrid instead? I began my code and kinda ran into a snag...
6
by: Brian Henry | last post by:
Here's an example of the code.. I have two combo boxes on screen that when one's selection is change the other's items will be updated to reflect the change (based on a relation) Private...
1
by: John Phelan-Cummings | last post by:
When I add the name of a new individual in a, bound form, it will not display that person’s name in a label control of a second unbound form. I have a scheduling program that I am working on. ...
0
by: brookhartc | last post by:
I am working on a program where I am retrieving data from an Access database through one common dataset. I have already put the database connection component on the form as well as the two data...
1
by: Ginger Estherskip | last post by:
I'm setting up a dataset using the GUI to have a Parent Data Table and a few Child Data Tables. I then have a form that uses that dataset, and I can fill the appropriate datatables et. al., but...
16
rpnew
by: rpnew | last post by:
Hello friends.... I'm developing one project in PHP-MySql on FC4..... I'm facing a problem here at one place. Let me describe it.... I've one page in php on which i'm generating a table...
1
by: Wingot | last post by:
Hey, I have an application codenamed WingFlex. It has a number of aspects to it, but the prudent parts for this problem are all within the "Client" Schema. The Client schema has three tables...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
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...
1
isladogs
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
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...
0
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

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.