Name: Access Error Message.png
Views: 15
Size: 70.0 KB
ID: 46235" class="size_large" />
I am receiving the above error message when I use Access Runtime with my database.
The steps I have are that the Main Menu Loads, I Open the first data entry form, for which there is one unbound field, the user selects the value, and clicks continue.
It then displays the following message.
The On click is VBA DoCmdOpenForm with Open Args.
The On Open event on the following page is purely open args.
I have lots of these all around the database and I have a very similar format on another database we have been using for ages, in fact this is almost the same, but cant fathom what causes this even.
It compiles fine. It runs fine on my computer, even when I spilt the database on the computer, but when I package it and open it on another computer it does this.
The onclick code is:
Code:
Private Sub Commandbtn_Click()
DoCmd.OpenForm "FrmReportingAccident", , , "[TypeofIncidentID]="& Me.[TypeofIncident].column(0),,,Me.TypeofIncident.Column(0)
DoCmd.Close acForm, Me.Name
End Sub
So I am passing the Primary Key from the Unbound form in the Bound Column of my ComboBox, in field TypeofIncident, not the value, to the Foreign Key on the receiving form.
Any ideas why this is not working, because it works everywhere else?