473,569 Members | 2,652 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access double click on record to open form but from two tables

1 New Member
Hi

To give a bit of background this is an asset register for all assets and pat testing database in one. Two tables concerned are asset register and risk assessments. The reason the tables are separate is because not all items will need a risk assessment.

I have a form for adding items to the register which has multiple tabs the first one fill out the asset register table and has a primary key of asset id which is auto number. The second tab fills out the risk assessment table which also uses asset id as a primary key but it is not autonumber, it copies it from the asset id in the first tab.

I would like users to be able to select a record from a subform and it open in the form to edit. I have managed to partly make this work based on this article. http://bytes.com/topic/access/answer...ecord-new-form
However using that solution it only imports the data from the asset register table. How do I get it to check if there is a matching record in the risk assessment table and then bring that information up for editing.

Thank you in advance
Oct 30 '15 #1
0 1286

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

Similar topics

1
4423
by: Dalan | last post by:
I probably just need a simple piece of code to do this as the couple tried so far have failed. I created a new Access 97 Form Filter (frmFilterForm) which displays most of the key data fields from the main form (frmMain) records. What I'm trying to do is simply double click on an autonumber ID column record in frmFilterForm and have it to...
2
7965
by: Bill Hand | last post by:
Is it possible to open a form from table and have it access a given record? I want to be able to query all baseball cards with the last name Jones and have it open a table. In each record of the table I have a hyperlink field that opens a form. Now say I have 10 Jones' and I want the form to open up to Andruw Jones not Chipper Jones. Is...
4
6192
by: Savita23 | last post by:
Hi, I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can fire the double click event of Detail section of the subform from the main form?I can't find this event. As of now,I am invoking the procedure in the Form_DblClick...
2
3474
by: David Haskins | last post by:
I have a fairly complex interface screen (form) that is comprised of several subforms that perform different, but related activities. I am designing a search/filter form that should be able to change the data displayed in one or more of the other forms, but I cannot find the way to change the Recordsource property of the second form from the...
2
2521
by: HowHow | last post by:
Access 2000. In a form, I have a subform showing simply names and contact numbers. I need a pop up contact form (related contact detail like job title, address, email..ect) when double click on a specific name. This pop up form will not show other contact person but will allow me to do editing or deleting on that specific person that I double...
3
1729
by: Zippy | last post by:
I have recently moved from A97 to A2003. I find it inconvenient that I can no longer double-click on the subform to open it in full view. I had a hunt around the newgroups and couldn't find anything helpful. I know that I can right-click to open, but is there anything I can do to make it do it the 'good old way'? -- Zippy S
3
3599
by: thayes5150 | last post by:
I have an Access 2003 database used to research unemployment claims. The main form contains a subform in datasheet view listing the employee claim records, including employee Social security number. I would like them to be able to double Click a record in this datasheet and have it open a subform, populated from a Query that is passed the SSN...
1
1382
by: Ana sid | last post by:
Hi. I want to access the buttons on one form from another form to control the visibility of the buttons.
4
1990
by: spleewars | last post by:
I've been struggling several time with this problem and apparently its driving me a little crazy: i have this code Private Sub CodeNumber_DblClick(Cancel As Integer) DoCmd.OpenForm "Products", , , _ "=" & "'" & Me.CodeNumber & "'" End Sub I cannot understand why on other forms this code works flawlessly and sometimes on others...
0
7924
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. ...
1
7676
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...
0
7974
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 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...
0
6284
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...
1
5513
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...
0
3653
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...
0
3642
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2114
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
1
1221
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.