fields cannot update in subform?

[PattiP]

I have 3 tables:

tblDate:
DateID
EventDate

tblEvent:
EventID
Event

tblTime:
TimeID
DateID
EventID
TimeOFF
TimeON


I created a form/subform where the EventDate is the main form. The subform
includes Event, TimeOFF, TimeON. The subform will not let me enter data. I
don’t want to add to the Event table, I want to select from the Event table
from a list box/combo box, but that doesn’t work either. Also, I get the
following error in the TimeOFF and TimeON fields: join key of tblTime not in
recordset.

What am I doing wrong?

 

[John W. Vinson]

I have 3 tables:

tblDate:
DateID
EventDate

tblEvent:
EventID
Event

tblTime:
TimeID
DateID
EventID
TimeOFF
TimeON


I created a form/subform where the EventDate is the main form. The subform
includes Event, TimeOFF, TimeON. The subform will not let me enter data. I
don’t want to add to the Event table, I want to select from the Event table
from a list box/combo box, but that doesn’t work either. Also, I get the
following error in the TimeOFF and TimeON fields: join key of tblTime not in
recordset.

What am I doing wrong?

Hard to tell because you don't say what you're doing! What are the
Recordsource properties of the mainform and subform? Is it really a Subform
(in a Subform control on the main form), or are you popping up a second form?
If it's a subform, what are the Master and Child Link Field properties?

Do note that your tables are at least a bit strange. What's the purpose of
EventDate, as opposed to just having a Date/TIme field in tblEvent? What's the
purpose of tblTime: does an Event have multiple "times" (of sub-events)? If
you're just trying to keep track of the starting and ending time of each
Event, I'd really suggest using a Date/Time field for TimeON and TimeOFF,
storing the date and time (use a display format which will display both).

 

[Gina Whipp]

PattiP,

Okay before we can help going to need some background...

I get tblEvent, what I don't get it tblDate and tblTime, why are they broken
up and please label Primary Keys (PK) and Foreign Keys (FK).

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm