Search results

I had a similar problem and found a work around. refer to my post to see it. I would like some details for how you solved it. Thank you,

Here is a solution, though it wont work for me because I have existing records. Change the relationship for tblIncident and tblDN from 1 to many to 1 to 1. Once I made that change the query was updatable and the form responded to a DoCmd.OpenForm. Now, how do I enter the 48 existing records...

Ok, I found the problem, the form's data source is a query that gets its data from 3 tables. The main table "tblIncident" has a 1 to Many relationship with "tblDN" and "tblVehicle". tblDN and tblVehicle are not related. this is causing the query to be Un-updatable. How this keeps the form...

I will try zipping it tomorrow.

We have been using it since Jan 2014, currently Approx. 2600 records some with file attachments. I recompile at least once a month.

Information only,:Like many, I am self taught, I'm always learning. I do not get insulted by corrections.

This form is actually supposed to be called from a combobox: the code is: Private Sub cboSelectForm_AfterUpdate() Dim strForm As String If Me.cboSelectForm = "Alarm Record" Then strForm = "frmAlarmRecord" ElseIf Me.cboSelectForm = "Vehicle Record" Then strForm = "frmVehicleRecord"...

The DB is 188 MB in size. Can I send it to another location? I have seen the table.field syntax before and the IncidentID is on all 3 forms. I even made the fields visible in case that was affecting it.

I've tried using: DoCmd.OpenForm "frmDriverNoticeRecord", , , "IncidentID = " & Me.IncidentID and DoCmd.OpenForm "frmDriverNoticeRecord", , , "IncidentID = " & Me![IncidentID] and DoCmd.OpenForm "frmDriverNoticeRecord", , , "IncidentID = " & Me.ActiveControl They give the same result...

Thank you so much for the quick response. I've been knocking my head on teh wall since last Friday. The field name is spelled correctly and the field is present on the main form and subforms. The main to child links are set. I use this little block of code on several other forms and it works...

Hello everyone, I have a main form "frmDriverNoticeRecord" with 2 subforms, "frmSubDriverNotice" and "frmSubVehicleRecord" The main form uses "IncidentID" as the PK. Each form stores data in its own table. The tables are related via IncidentID and there is a 1-many relationship between...

I'm Rico, I have become the inadvertent MS Access person for my department. I am fairly new to the platform. I completed my first 2 DBs and they are in production. so I am a newb who has managed to fool everyone here at work. :) I mountain bike, now more for pleasure than anything else. I ride...