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 |
#31
|
|||
|
|||
purpose of subform?
On Thu, 1 Jan 2009 16:19:00 -0800, mike
wrote: the default view property is not avaliable for subform but its available for the main form? Are you looking at the properties of the Subform Control (the box on the mainform containing the subform) or the properties of the Form object inside that control (the latter is where you want to be)? -- John W. Vinson [MVP] |
#32
|
|||
|
|||
purpose of subform?
Are you looking at the properties of the Subform Control (the box on the
mainform containing the subform) or the properties of the Form object inside that control (the latter is where you want to be)? Bingo. that was it |
#33
|
|||
|
|||
purpose of subform?
its me again just so you know i'm almost there. was asked to add
additional items which was easy since i was using relationships. newest issues since adding more fields/tables... -when i add record to tblStudentSubject it overwrites existing record instead of appending? -how do i reset cbo to blank upon exit or enter...the last items selected default to the cbo's when i reopen. "mike" wrote: Are you looking at the properties of the Subform Control (the box on the mainform containing the subform) or the properties of the Form object inside that control (the latter is where you want to be)? Bingo. that was it |
#34
|
|||
|
|||
purpose of subform?
i found my problem...didnt realize subform was displaying multiple records,
kept changing same record which is why the overwriting was occurring but that leads me ... how do i make the blank record default to the subform so other teachers dont/cant change previous selections? or will the db splitter ensure previous records cannot be altered? "mike" wrote: its me again just so you know i'm almost there. was asked to add additional items which was easy since i was using relationships. newest issues since adding more fields/tables... -when i add record to tblStudentSubject it overwrites existing record instead of appending? -how do i reset cbo to blank upon exit or enter...the last items selected default to the cbo's when i reopen. "mike" wrote: Are you looking at the properties of the Subform Control (the box on the mainform containing the subform) or the properties of the Form object inside that control (the latter is where you want to be)? Bingo. that was it |
#35
|
|||
|
|||
purpose of subform?
On Tue, 6 Jan 2009 13:26:00 -0800, mike
wrote: newest issues since adding more fields/tables... -when i add record to tblStudentSubject it overwrites existing record instead of appending? What's the Recordsource property of the subform? What controls are on it, and what are their Control Sources? -how do i reset cbo to blank upon exit or enter...the last items selected default to the cbo's when i reopen. Sounds like you may have the combo box unbound. As a rule the combo should show the value that's actually in the table; you need to navigate to the blank "new record" to add a new record! -- John W. Vinson [MVP] |
#36
|
|||
|
|||
purpose of subform?
you need to navigate to the blank "new record" to add a new record!
-that was it -how can i get the subform to default to a new record when the program opens? -since all records in the table are present in the subform, what's to prevent a user from changing an existing record? thx. |
#37
|
|||
|
|||
purpose of subform?
On Tue, 6 Jan 2009 13:37:01 -0800, mike
wrote: i found my problem...didnt realize subform was displaying multiple records, kept changing same record which is why the overwriting was occurring but that leads me ... how do i make the blank record default to the subform so other teachers dont/cant change previous selections? or will the db splitter ensure previous records cannot be altered? Splitting will NOT permanently lock records... and as a rule you wouldn't want to do so! Do your teachers never make mistakes and need to correct an entry which was made previously!? You can set the subform's Data Entry property to True; this will let you enter new records but not even *see* old ones. Or, you can set the form's Allow Additions property to Yes but Allow Edits to No to display old records but prohibit adding new ones. I'd really recommend using a Continuous Form for the subform, and make it big enough that you can see the blank new record at the bottom; or you can put some VBA code in the subform's Open event to navigate to the new record: click the ... icon by the Open event property on the form and choose Code Builder, and edit it to Private Sub Form_Open(Cancel as Integer) DoCmd.GoToRecord, , acNewRecord End Sub -- John W. Vinson [MVP] |
#38
|
|||
|
|||
purpose of subform?
i'm such a knuckle head...the cmdBtn to add new record does this (duh).
"John W. Vinson" wrote: On Tue, 6 Jan 2009 13:26:00 -0800, mike wrote: newest issues since adding more fields/tables... -when i add record to tblStudentSubject it overwrites existing record instead of appending? What's the Recordsource property of the subform? What controls are on it, and what are their Control Sources? -how do i reset cbo to blank upon exit or enter...the last items selected default to the cbo's when i reopen. Sounds like you may have the combo box unbound. As a rule the combo should show the value that's actually in the table; you need to navigate to the blank "new record" to add a new record! -- John W. Vinson [MVP] |
#39
|
|||
|
|||
purpose of subform?
john,
i click new record and when i select a student from the cbo i get the following dialog box: "The object doesnt contain the Automation object StudentID..." which only started happening after i rebuilt my subform using new tables/fields, any idea what's the cause of this? "John W. Vinson" wrote: On Tue, 6 Jan 2009 13:26:00 -0800, mike wrote: newest issues since adding more fields/tables... -when i add record to tblStudentSubject it overwrites existing record instead of appending? What's the Recordsource property of the subform? What controls are on it, and what are their Control Sources? -how do i reset cbo to blank upon exit or enter...the last items selected default to the cbo's when i reopen. Sounds like you may have the combo box unbound. As a rule the combo should show the value that's actually in the table; you need to navigate to the blank "new record" to add a new record! -- John W. Vinson [MVP] |
#40
|
|||
|
|||
purpose of subform?
On Tue, 6 Jan 2009 17:16:05 -0800, mike
wrote: john, i click new record and when i select a student from the cbo i get the following dialog box: "The object doesnt contain the Automation object StudentID..." which only started happening after i rebuilt my subform using new tables/fields, any idea what's the cause of this? What's the Recordsource for the subform (post the SQL)? What's the Control Source of the combo? My guess is that the combo has a control source that is not a fieldname in the new table. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|