January 1st, 2009, 02:49 AM
posted to microsoft.public.access.forms
|
|
purpose of subform?
i hear ya. duly noted
"Gina Whipp" wrote:
You're most welcome...
Ummm, as a sidenote, "fiddle" on a copy. You don't want to accidently
"fiddle" with the working one and have it stop working!
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
Gina, John (Vinson), and Allen (Browne):
wanted to say thank you for your gracious help. thx to Allen and John i
was
able to "properly" construct a DB using relationships, and thx to Gina for
helping me bring it all together.
john: i agree with your point about the confirmation button. going to
omit
it for now.
as a teacher, i have an appreciation for people who are willing to share
his/her knowledge for the sake of helping
all in all i've got what i set out the create. could use a few bells and
whistles but i can fiddle with it now.
Regards.
Mike
"Gina Whipp" wrote:
Yes, that will work...
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
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?
|