displaying an field from an unlinked table on a form.

  • Thread starter Thread starter Joseph Meehan
  • Start date Start date
J

Joseph Meehan

I would like to display a field (or other source) from a back end
database as a "label" on a form based on a table in the same back end.

I want to be able to change the label in all the user front ends at will
from the back end database. I can use a dedicated table with only one
record or a standard link or if there is some way of using a string defined
in VBA in either or both of the databases.

Right now I am doing it using a table, but it updates at each record
change so there is a delay when the user changes records. The label is
blanked as the user advances to the next record and there is a delay after
the record is found and displayed while the "label" data is refreshed and
displayed.

If I could set just that field to refresh only one opening of the form
that would work.
 
So that you are not constantly refreshing the record, why don't you either
create a hidden form that looks up and maintains the value in a textbox. Or
if you want something even simpler, you can create a module with a single
public variable (also called a global variable) which will look up the value
when you open your database or upon first use, depending upon how you set it
up.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I was trying your second suggestion, but clearly I never got it right.
Got any sample code I might steal?

I'll give your first suggestion a try.
 
Back
Top