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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
fields cannot update in subform?
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? -- Patti |
#2
|
|||
|
|||
fields cannot update in subform?
On Thu, 29 Oct 2009 13:41:02 -0700, PattiP
wrote: 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). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
fields cannot update in subform?
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 "PattiP" wrote in message ... 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? -- Patti |
#4
|
|||
|
|||
fields cannot update in subform?
matthew
87e263 "PattiP" wrote in message ... 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? -- Patti |
Thread Tools | |
Display Modes | |
|
|