Form 1 opens form 2 to matching record

[Jonny45wakey]

Hi

I have a form "frmDayshift" which has field [shiftdate], this form has a cmd button when clicked i want it to open a second form "frmdayshiftprintcheck" to same record date as form 1 [shiftdate], form 2 date field = [checkdate]

ive tried vba such as:-

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=#" & Me.ShiftDate & "#"

But is doesnt seem to open to the right record.

Any ideas welcomed

Many thanks

Jonny

 

[arnelgp]

maybe try:

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=#" & Format$(Me.ShiftDate, "m/d/yyyy") & "#"

 

[cheekybuddha]

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=#" & Me.ShiftDate & "#"

But is doesnt seem to open to the right record.

Are you in the UK?

When constructing dates in SQL you must use an "unambiguous date format" which translates to "yyyy-mm-dd" or "mm/dd/yyyy"

Try adjusting to:

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=" & Format(Me.ShiftDate, "\#yyyy\-mm\-dd\#")

hth,

d

 

[Gasman]

Hopefully you would have an autonumber and could just use that?
Much, much easier.

 

[Jonny45wakey]

maybe try:

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=#" & Format$(Me.ShiftDate, "m/d/yyyy") & "#"

maybe try:

DoCmd.OpenForm "frmDayShiftprintcheck", , , "[CheckDate]=#" & Format$(Me.ShiftDate, "m/d/yyyy") & "#"

arnelgp, your solution worked perfectly, thankyou for solving this for me, much appreciated

REgards

Jonny