If someone could simply tell me if I'm in the right direction
- i have a table [Re****tList] with 2 fields: [Re****tCommonName] and
[Re****tName]
- on a form, i have a combobox: cboRe****tSelect with [Re****tCommonName] as
its datasource
- the user's selection in the cbo will determine what [Re****tName] will be
used in in a "print re****t" command
- i think i need to set up a global variable [vRe****tName] and assign to
it
the value of the [Re****tName] where [Re****tCommonName] = cboRe****tSelect
- i am trying to use this line of code:
vRe****tName = DLookup("[Re****tName]", "Re****tList",
"[Re****tCommonName] = cboRe****tSelect.value")
(but am not having much luck)
- i would then use the variable in a line of code something like this:
Dim blRet As Boolean
blRet = ConvertRe****tToPDF("vRe****tName", vbNullString,
"temp.pdf",
False, True, 0, "", "", 0, 0)
thanks in advance,
mark
|
