Hi,
I've been searching through the forums for the last few hours but I have not seen a workable answer for this...
So Basically the title says it all. I've got a form in which I create a roster list on... and to save space I would like to create a pop up form to add notes to a particular day.
The construction of my Database is a follows...
I have a main table called tbl_day, this creates a dayID for every other table to work from and in turn links into.
I have created a Notes table (tbl_notes) with the columns [NoteID], [Note] & [DayID]
I tried the Where Condition... from http://www.baldyweb.com/wherecondition.htm
using
DoCmd.OpenForm "frm_rosternotes_C", , , "DayID = " & Me.dayID
This opens my pop-up form but doesn't link in the DayID field with the main form. I appreciate that this command is looking for a record in my notes table a record to match the DayID part to.
Sorry if this sounds confusing... and will clarify anything. I've attached a screenshot of the form this is associated too (although the button used has been deleted in this screenshot)
I've been searching through the forums for the last few hours but I have not seen a workable answer for this...
So Basically the title says it all. I've got a form in which I create a roster list on... and to save space I would like to create a pop up form to add notes to a particular day.
The construction of my Database is a follows...
I have a main table called tbl_day, this creates a dayID for every other table to work from and in turn links into.
I have created a Notes table (tbl_notes) with the columns [NoteID], [Note] & [DayID]
I tried the Where Condition... from http://www.baldyweb.com/wherecondition.htm
using
DoCmd.OpenForm "frm_rosternotes_C", , , "DayID = " & Me.dayID
This opens my pop-up form but doesn't link in the DayID field with the main form. I appreciate that this command is looking for a record in my notes table a record to match the DayID part to.
Sorry if this sounds confusing... and will clarify anything. I've attached a screenshot of the form this is associated too (although the button used has been deleted in this screenshot)
