am*******@verizon.net (amywolfie) wrote in message news:<33**************************@posting.google. com>...
Hi all:
I develop in both FileMaker Pro and Access. FileMaker has a global
field type, whereby the value of the gfield is the same for all
records.
Is there an equivalent in MS Access (2002)?
I don't want to set a variable in VB, since the value of the global
will change and requires input from the user.
Thanks!
===
If you need to keep the value of the what would be the global field in
Access, you would have to write the value to either a table or to a
custom field, which you could retrieve as needed. Probably easier to
use the method Steve suggested, though. One way to change the value
is to let the user enter it in a form, validate it, and then write it
to the table. If you're going to just use the global field like an
accumulator variable or a counter, as you would if you were doing
loops in FileMaker, then you could just declare a variable in your
subroutine in VB.