Yes, you can use DLookup on a check box.
The problem with your expression is that you are looking up a field named
"Forms![ScanForm].JobCancel" from the "P Job Table".
DLookup syntax is DLookup ("FieldName","TableName",<criteria>)
If your field name in the table is "JobCancel", the following should work
(assuming your criteria is correct):
=DLookUp("JobCancel","P Job Table","[P Job Table].ReworkNo =
Forms![Scanform].ReworkNo")
HTH,
Toby
----- Original Message -----
From: "brazilianbound" <[EMAIL PROTECTED]>
To: <AccessDevelopers@yahoogroups.com>
Sent: Friday, December 16, 2005 1:14 PM
Subject: [AccessDevelopers] Re: DLookUp on a check box?
> Hey Toby
>
> I guess my system has just been weirding out - the macro, expression
> builder is working again.
>
> In another vein, Can you use DLookup on a check box? I've trying
> atlease a dozen expression, but I can't get the box to get a check
> mark in it even if the record i'm referencing does?
>
> Here's my current express - any ideas?
>
> =DLookUp("Forms![ScanForm].JobCancel","P Job Table"," [P Job
> Table].ReworkNo= Forms![Scanform].ReworkNo ")
>
> Thanks!
> Happy Holidays
> Clayton
>
>
> --- In AccessDevelopers@yahoogroups.com, "Toby Bierly" <[EMAIL PROTECTED]>
> wrote:
> >
> > I'm assuming you are talking about programming what to do for an
> Event (like
> > AfterUpdate). In the Properties for an Object, on the Event tab,
> their is
> > the ellipses (...) to the right of each event. If you have
> defined some VBA
> > code for that event, the line will say "Event Procedure" in it.
> Clicking
> > the ellipses will take you straight to the Code window. If you
> want to
> > define an expression or marco [sic], then delete the "Event
> Procedure" text
> > (in the properties window) and then click on the ellipses again.
> You should
> > be able to choose Expression, Macro, or Code Builder.
> >
> > HTH,
> > Toby
> >
> > ----- Original Message -----
> > From: "brazilianbound" <[EMAIL PROTECTED]>
> > To: <AccessDevelopers@yahoogroups.com>
> > Sent: Friday, December 16, 2005 5:53 AM
> > Subject: [AccessDevelopers] expression builder unavailable
> >
> >
> > > Morning Folks -
> > >
> > > I've noticed that since i've used some VBA code, that i can't
> seem to
> > > get the expression or marco builder window to popup. Is there a
> way i
> > > can get that feature back?
> > >
> > > Thanks!
> > >
> > > Clayton
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Please zip all files prior to uploading to Files section.
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > BEGIN-ANTISPAM-VOTING-LINKS
> > > ------------------------------------------------------
> > >
> > > Teach CanIt if this mail (ID 27145397) is spam:
> > > Spam:
> > http://web2.cleanmessage.com/b.php?c=s&i=27145397&m=5de02f8fbb91
> > > Not spam:
> > http://web2.cleanmessage.com/b.php?c=n&i=27145397&m=5de02f8fbb91
> > > Forget vote:
> > http://web2.cleanmessage.com/b.php?c=f&i=27145397&m=5de02f8fbb91
> > > ------------------------------------------------------
> > > END-ANTISPAM-VOTING-LINKS
> > >
> >
>
>
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> --
> BEGIN-ANTISPAM-VOTING-LINKS
> ------------------------------------------------------
>
> Teach CanIt if this mail (ID 27165536) is spam:
> Spam:
http://web2.cleanmessage.com/b.php?c=s&i=27165536&m=5cc0c177c467
> Not spam:
http://web2.cleanmessage.com/b.php?c=n&i=27165536&m=5cc0c177c467
> Forget vote:
http://web2.cleanmessage.com/b.php?c=f&i=27165536&m=5cc0c177c467
> ------------------------------------------------------
> END-ANTISPAM-VOTING-LINKS
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/.QUssC/izNLAA/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/
