Search results

Galaxiom, Thanks for the reply. I read your post, I read the thread that you referred to and I looked at the sample grades.mdb. I'm not seeing how these approaches would allow me to automatically generate the records I need. It appears that the user still needs to manually enter the data...

JHB, Thanks for the suggestion. I looked into Append/Insert Queries and gave it a shot. Believe it or not, it actually worked! Amazing! I used an SQL Insert query for each new record in the After Update event of the cboType combo box. Uncle Gizmo, since I was frantically typing code when...

I have a main form called frmItemDetail. Inside frmItemDetail, I have a subform called frmActivity. Nested within frmActivity is a subform called frmCategory. frmActivity is linked to the frmItemDetail by ItemID and frmCategory is linked to both its parents with ItemID and StageID and things...

Is there any way to combine this method with another format? For example, is there a way to enter @;"Date" in the format property AND "short date" so that the field will still be a date field? Or @;"Price" for the placeholder AND "Currency" as the actual format?? Thanks

That makes sense. Thanks

Yes, the message box still works if I use Me.Parent.Form.cboPhase. I wonder if this is "normal" behavior

Colin, Are you serious? It was that simple? Really? Unbelievable... Parent.Form.cboPhase worked. For some reason Me.Parent.Form.cboPhase didn't. I don't get it, but I'm happy it works. I can't thank you enough for your help with this. Would you be able to explain why my MsgBox could...

I have a form in single form view, called frmProjectsNew. On that form, I have a subform in datasheet view, called frmIncomeSub. Nested within frmIncomeSub, I have another subform in datasheet view, called frmExpensesSub. Both subforms are linked properly with Master & Child fields. On the...