Re: Table design help

Multiple tables is incorrect. You need:

TblOutcome
OutcomeID
OutcomeDate
OutcomeTime
IsAchieved (Yes/No)
Comment

On FrmOutcome, disable comment. Put the following code in the AfterUpdate
event of IsAchieved:
If Me!IsAchieved = True Then
Me!Comment.Enabled = True
Else
If Me!Comment Is Not Null Then
If MsgBox("Do You Want To Delete The Comment?",vbYesNo) = vbYes Then
Me!Comment = Null
End If
End If
Me!Comment.Enabled = False
End If

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"JEM" <JEM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:76E9769E-6BB0-4DA8-965F-B8A8724F23D0@xxxxxxxxxxxxxxxx
I have to create a database which monitors outcomes every four hours. I
have
created a table which covers 1 day and have then copied this to make the
2nd
day and so on. The problem I have, this monitoring can last 1 day or it
has
been known to last up to 6wks in some cases. Is there an easier way to do
this as the dates of when it starts and finishes are important.

Also for each outcome a yes or no has to be achieved, if a no has been
input
I have made a subtable to record the no's and why they have happened.
Rather
than have to click on the +sign to bring up the subtable is there anything
I
can put in the field that when a no is recorded it automatically brings up
the subtable and will this work if I I make up a form?

Thanks for any help in advance.


.

Loading