Opening Specific Records using a button

[Dan9684]

Try:



stLinkCriteria = "[GIOCode]=" & Me![GIOSearch] & " And [MonthEnding]=#" &format(Me![MonthSearch],,"MM/DD/YYYY") & "#"

Cheers,
Vlad

Type mismatch

[Gicu]

Wrap it in a CDate:

stLinkCriteria = "[GIOCode]=" & Me![GIOSearch] & " And [MonthEnding]=#" & CDate(Format(Me![MonthSearch],,"MM/DD/YYYY")) & "#"

Vlad

[Dan9684]

Wrap it in a CDate:

stLinkCriteria = "[GIOCode]=" & Me![GIOSearch] & " And [MonthEnding]=#" & CDate(Format(Me![MonthSearch],,"MM/DD/YYYY")) & "#"

Vlad

Still a type mismatch.

[Gicu]

What data types are the two fields in the table?

[Gicu]

Sorry, just spotted a spelling mistake (two commas instead of one), try:
stLinkCriteria = "[GIOCode]=" & Me![GIOSearch] & " And [MonthEnding]=#" & CDate(Format(Me![MonthSearch],"MM/DD/YYYY")) & "#"

Cheers,
Vlad

[Dan9684]

Sorry, just spotted a spelling mistake (two commas instead of one), try:
stLinkCriteria = "[GIOCode]=" & Me![GIOSearch] & " And [MonthEnding]=#" & CDate(Format(Me![MonthSearch],"MM/DD/YYYY")) & "#"

Cheers,
Vlad

Thanks, doesn't report a type mismatch any more, just returns a blank record.

In the frmMain, GIOCode is Number. Field Size = Long Integer, decimal places = Auto
MonthEnding is Date/Time

In the frmMenu the GIOSearch and MonthSearch are exactly the same as the corresponding two above.

It's almost certainly a formatting issue I guess?

[Gicu]

Have you checked the control names in both forms, are they the same as in your code?

Cheers,
Vlad

[Dan9684]

Have you checked the control names in both forms, are they the same as in your code?

Cheers,
Vlad

Yep identical