By "pass that number into another table", do you mean that you want to add
that number to another table? If so, an append query should work.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6831-re-passing-variables-to-a-field.html Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6831
Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________
"sjk153" wrote:
I have a function that returns the value of the last autonumber from a table
and want to pass that number into another table? Any thoughts on how to do
it?