Thank you... it took me a minute to comprehend it all but it works perfectly!
Thanks again. --- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > > All fields in each row must be bound to data fields. Your text box > sounds like it isn't bound to any field, so when you change one, they > all change. Your check box needs to have code behind it so that when it > is checked or unchecked, the textbox gets a value or that value is > cleared. The checkbox also must be bound to a field in the table. So, > for example, in the OnClick event for the checkbox, your code says: > > If Me.chkYes = True then > Me.txtDateField = Forms!MainForm!txtDate > Else > Me.txtDateField = "" > End If > > Hope this helps. > > Tobi > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of martybevo > Sent: Monday, November 07, 2005 1:40 PM > To: [email protected] > Subject: [AccessDevelopers] Conditions? > > > Hello, > > I'm working with a continuous form where each row contains one > record. I don't know how to express what I'm trying to do but I'll > give it a whirl... > > Each row contains a first name, last name, check box and a blank > field. > What I want is when I place a check mark in the box a value from > another form (via a simple text box)appears in the blank field. > > For example, in Form A I placed a date value of 10/31/2005 in a text > box... I then move onto Form B and I see a list of 3 people, with a > check box option and a blank text field next to their names. > > Let's say I go to the second line and select the check box... now, on > that blank field I want the date (10/31/2005) to appear from the > previous form field. > > Also, to complicate matters... if I uncheck the box then I want to > date to go "blank" again. > > Can anyone assist me please? > > PS - Using the "On Click" event I'm able to capture the date field, > however, it places the value on all records. I know it's wrong but I > feel I'm getting so close. > > Thank you. > > Domenic > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
