stLinkCriteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following command to get a specific record:
stLinkCriteria = "[bid-number]=" & bnum And "[bid-suffix]=" & bsuffix
I sure that I coded it wrong, can some one help me?
My control fields are 'bid-number and bid-suffix' I am trying to get a
specific record to update whats wrongs.
 
What are the data types of the two fields? If they're text, you need to put
quotes around the values:

stLinkCriteria = "[bid-number]='" & bnum & "' And [bid-suffix]='" & bsuffix
& "'"

Exagerated for clarity, that's

stLinkCriteria = "[bid-number]= ' " & bnum & " ' And [bid-suffix]= ' " &
bsuffix & " ' "

If they're numeric, your original quotes were wrong:

stLinkCriteria = "[bid-number]=" & bnum & " And [bid-suffix]=" & bsuffix
 
Back
Top