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: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of martybevo
Sent: Monday, November 07, 2005 1:40 PM
To: AccessDevelopers@yahoogroups.com
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/
