every time form load two field set to ...

[smahdih]

hi every body

i have a problem, i created a form base on a table and created a query with "Where" condition, then created a report base on query

in on click event reprot i wrote

DoCmd.OpenForm "frmTable1", acNormal, , "OrderCode = '" & Me.OrderCode & "'"
DoCmd.Close acReport, "rptqryPending", acSaveNo

but evert time "frmTable1" open , Description and OrderTime fields set to -1 and 00:00 ,
how can fix it?

if need to more explain i can attach database

 

[vbaInet]

What mode do you open the form in? Does it open up to a new record (for example)?

You have probably formatted those controls using the Format property.

 

[smahdih]

What mode do you open the form in? Does it open up to a new record (for example)?

You have probably formatted those controls using the Format property.

those format property is same,

i've attached photo,

wrote in on click event report

DoCmd.OpenForm "frmTable1", acNormal, , "OrderCode = '" & Me.OrderCode & "'"
DoCmd.Close acReport, "rptqryPending", acSaveNo

those field formatted as short time

how could something possible?

 

[vbaInet]

Remove the property and you will see what I mean.

Once you understand what's going on I will tell you how to re-write it.