View Single Post
  #17  
Old December 31st, 2008, 05:06 PM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

Gina,

i'm using 2003.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

since the cbo's are bound to fields in tblStudentSubject, when i select a
cboStudent and then select a cboSubject, it creates a new record in
tblStudentSubject which is what i want. however, i'd like to add a
confirmation step. after user selects subject use a messageDialogBox to
confirm entry.

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub

will that do it?