A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Tab Question



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2008, 02:44 AM posted to microsoft.public.access.forms
sj
external usenet poster
 
Posts: 85
Default Tab Question

I am using Access 2000. I have a form with 5 tabs. The first tab is data
taken at intake interview for a patient. The second through the fifth is for
subsequent patient visits. The requirement is to be able to change certain
fields without altering the inital intake information in the first tab; for
eg. the address fields if at the second visit, the patient's address has
changed, I should be able to enter the new address without changing the
address at intake. However, going forward the data from the most recent tab
should be picked up for the following tabs. Is this doable in Access - can
somebody please help?
Thanks
  #2  
Old April 28th, 2008, 04:22 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default Tab Question

It isn't the form, that stores the data, it is the underlying table(s). If
you have many side table(s) that allow the storage of multiple values for
each of the patients, it should be rather easy to accomplish your goal. Add
a timestamp (date/time field) to each record so that you can order them
appropriately.

Each of your tabs that show new data should only allow adding data, not
editing it. A bit of code in the form can write that data to a new record,
instead editing the existing one. The properties of the form and controls
that you need to familiarize yourself with a

OldValue, Dirty, and you will use the AfterUpdate event to cause the copy of
the record to a new one.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"SJ" wrote in message
...
I am using Access 2000. I have a form with 5 tabs. The first tab is data
taken at intake interview for a patient. The second through the fifth is
for
subsequent patient visits. The requirement is to be able to change certain
fields without altering the inital intake information in the first tab;
for
eg. the address fields if at the second visit, the patient's address has
changed, I should be able to enter the new address without changing the
address at intake. However, going forward the data from the most recent
tab
should be picked up for the following tabs. Is this doable in Access - can
somebody please help?
Thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.