var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Linking criterias
I need some help on something.
I have a main form with an MID and a text field, MText. By clicking on a command button I want it to open a separate form by the the criterias of MID and MText with OID and OText.
This is what I have at the moment but it is coming up with Type Mismatch
Dim stDocName as string
Dim stLinkCriteria as string
stDocName = "frmName"
me![MText] = "Item 1"
stLinkCriteria = "[MID]=" & me![OID] and "[OText]=" & "'" & me![MText] & "'"
You will notice that I have MText to become a string of "Item 1". This is because I want to link the field name with the OText instead of the value.
Any ideas would be appreciated.
Ok let me try and make it a little simplier.....
I have just got this help from Access
stLinkCriteria = "[MID] = " & me![OID] ' this one works
stLinkCriteria = "[MText] = 'Text' ' this one also works
but as soon as I do this:-
stLinkCriteria = "[MID] = " & me![OID] and "[MText] = 'Text' (just joining them together because I need multiple criterias) it comes up with the following error:-
I'm sure it is so simple but just can't work it out.