Обсуждение: select nextval. . .

i am connecting to a postgres 6.4.2 database with msaccess97.  in that 
postgres database i have a sequence defined.  in access i have a form, with 
only one textbox -- when i open that form i'd like to populate that textbox 
with the next value in that sequence.  i can get the next value from psql 
(select nextval('sequencename');), but i can't seem to figure out how to 
get that nextval from within access97 into a control on a form.  i can 
design a pass-through query that inserts the nextval into a database, but 
that isn't what i want to do (it also exposes some risk of non-uniqueness 
that the sequence helps to ensure).  got any ideas??

jt