I've Broken Rod's Code - 'Datatype Mismatch' in form event procedure

[Scifi67]

Dear All (Especially Rod),

I've been trying to rewrite my database, hopefully, incorporating Rod's suggestions; from my previous version.
However, I've broken the VBA code

When I try to enter a new Examination report, using the form, I get a 'Datatype Mismatch' error.

I've looked in to everything, the only thing I can see (when it errors), the value of TEPreD; in the code window (when hovering the mouse over it); shows as a time?

I'm not sure if there's something I'm not understanding with regard to the PK/FK relationship either.
I think I have checked all the date formats, in the tables, forms & queries.



The code is supposed to check for and (if present) insert a previously entered date in the field 'TEPreD'

I would appreciate anyone looking at this and letting me know what I'm missing/doing wrong, please.
Didn't want to pester Rod directly (I'd need to start paying him a retainer )

Dave...

[Missinglinq]

The code is supposed to check for and (if present) insert a previously entered date in the field 'TEPreD'

What code? Posting the app is fine, but not giving an explanation and expecting anyone to slog through all of this, trying to reproduce your problem, is not apt to get much help, I'm afraid. You really should always post the errant code here and/or give us some step-by-step instructions on reproducing it.

Your problem, I think, is not with TEPreD, it's with FleetID. It is defined as a Number, in your underlying Table, but the line

Me.TEPreD = DMax("TEDate", "TblTEDetails", "FleetID = '" & Me.FleetID & "'")

uses the correct syntax for it as a Text Field! That is the 'type mismatch' error you're receiving. For a Number Field the syntax would be

Me.TEPreD = DMax("TEDate", "TblTEDetails", "FleetID = " & Me.FleetID)

Linq ;0)>

[Scifi67]

MissingLinq,

Thank you for looking at this, I will amend the code, tomorrow, when I get back to work.

My apologies & thanks, also, for your forum pointers; what you have pointed out never occured to me, but makes perfect sense.
I stripped out everything I could, without breaking functionality; never thought about someone looking through it for the 1st time.

[Missinglinq]

Glad to help! Get back to us if you have any further problems!

Linq ;0)>

[Scifi67]

Linq,

Thank you, worked like a charm

[Missinglinq]

Glad we could help!

Linq ;0)>