slight error in link criteria syntax code

[antonyx]

stLinkCriteria = "[JobRef]=" & "'" & Me![jobref] & "' & [fkAccountTypeID]=1"

the job ref is gathrered from my jobref control but the account type i want to set it to 1 manually..

this compiles but no values are sent across to my second form.. whats wrong?

 

[Bat17]

I think

stLinkCriteria = "[JobRef]='" &  Me![jobref] & "' AND  [fkAccountTypeID]=1"

Peter

 

[antonyx]

no same problem.. it compiles but nothing is sent across... the form that opens is just blank with no fields displaying

 

[antonyx]

ill just add that the below line successfully sends across the job ref.. im just trying to expand this statement now..

stLinkCriteria = "[JobRef]=" & "'" & Me![jobref] & "'"

 

[antonyx]

fkAccountTypeID is a number datatype

if we just look at this part..

[fkAccountTypeID]=1

is this the correct way to assign a number value to a number datatype??

 

[antonyx]

this doesnt even work..

stLinkCriteria = "[fkAccountTypeID]=1"

 

[Bat17]

check the spelling of fkAccountTypeID and make sure that its data type is numeric

Peter