calling Subs

[Jacques Proot]

A> I cannot call a procedure from another object module
(within the same database) and there is no mention
of "private" nowhere. Why ?

B> How do we OPENFORM with a Visual Basic variable in the
WHERE clause ? Something like [field] = Variable. It is
not responding.

Thanks.

 

[rocco]

B) try [field]=" & "'" & variable & "'"
A) are you sure the called procedure is declared
with "public? like:
_____________
public sub routine.name
code here...
end sub
______