Prev: Access2007 - drag and drop into a form
Next: Set Querydef SQL to Null (Open an empty query editor)
From: efandango on 7 Dec 2009 18:41
I want to 'store' a number (which changes frequently) in an unbound text box,
but do not want it stored in any tables. Can this be done?

The number is used to reference a user start point, but I want it to still
be there when the database is reopened.
From: Dirk Goldgar on 7 Dec 2009 19:04
"efandango" <efandango(a)discussions.microsoft.com> wrote in message
news:A5F6D14E-3B48-4DD5-8A7E-3C6477AE8B01(a)microsoft.com...
>I want to 'store' a number (which changes frequently) in an unbound text
>box,
> but do not want it stored in any tables. Can this be done?
>
> The number is used to reference a user start point, but I want it to still
> be there when the database is reopened.


It's *possible* to store it in a database or form property, but it's
probably easier to store it in a table. Then you can use a simple DLookup
to get it from the table when the form is opened.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 | 
Pages: 1
Prev: Access2007 - drag and drop into a form
Next: Set Querydef SQL to Null (Open an empty query editor)