I am trying to achieve number 1 or 3, however I am having a couple of problems.
The first problem is that I keep getting the parameter value pop up thing coming up, any idea how to get rid of that?
Second problem is with the double click VBA(when i click on a click to open their profile):
The code is:
Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "Profile", acNormal, , "[FamilyID] = '" & Me.FamilyID & "'"
and i get this error message "Run time error '3464' Data type mismatch criteria expression"
I am using Access 2007/2010.
The forms that are in question are:
and the queries in related are:
I have attached a zipped profile which has dummy data.
Also, on a separate note. Is there a code that I can implement to stop the user from entering a file number twice? The file number is not the primary key, however is there some sort of lookup code that i can write to see if a particular number has already been entered and if it has an error message should occur?
Secondly, did you get a chance to check out the other problem I had? The parameter value box pops us. The only time I can type into the search box is when i come out of desgin view, then the parameter box pops up and I have to type in that.