Not sure of the best approach...?

  • Thread starter Thread starter James Franklin
  • Start date Start date
J

James Franklin

Hi,

Could someone please advise me on the best way (if there is one?) of doing
this...

I have an application which has 3 main form and will always have 3
concurrent users performing different functions. Each user will almost
always be using their own main form. Each main form is Unbound, but has
several subforms showing data, plus command buttons etc. Each main form has
a timer event to periodically requery the subforms to show the latest data.

I have a value which is constantly updated using VBA code, which is stored
in a one-field, one-record table, tbl_ATC. This value needs to be shown on
each of the 3 main screens. Should I...

1. Make each mainform bound to tbl_ATC and have the control on there in the
normal way? (Each table would have to have AllowAdditions and AllowDeletions
set to False and the control would be locked.)

2. Have another subform on each main form. The subform would be bound to
tbl_ATC and would not be editable etc.

3. Create a user-defined function to open the recordset for tbl_ATC and
return the field value. This function would then be the control source for a
control on each of the main forms.

Does it make a big difference? I am concerned about performance as each main
form is already doing quite a lot.

Any advice would really be appreciated. Thanks,

Jim F.
 
James

You are describing a single field, single row table that you want to display
the value of, right? You aren't allowing any change by the users, also
true?

You could solve this many ways, including a DLookup() function. If you are
concerned that there may be significant response time issues, you'll
probably have to test the different approaches, to find which one is
fastest. Your network configuration, your version of Access, the speed of
your PCs, etc. will probably contribute more delay than any but the most
inefficient Access technique.
 
Back
Top