Prev: Need a button to print 5 copies
Next: Sending a link for a form to the desktop - Access 2007
From: Wordwonderor on 24 May 2010 11:14
I've changed to a combo box. It seems to work. But I'd like to understand why
the DLook up didn't, as that approach sem to be more direct.

The Solicitor ID is a number field in the form's record source. It is tied
to the Contacts ID.

"BruceM via AccessMonster.com" wrote:

> Actually, I realize now that you did mention this, but I misunderstood the
> problem. Is SolicitorID a number field? Is the Solicitor text box bound to
> LName in the form's Record Source?
>
> Wordwonderor wrote:
> >Thank you, but it didn't help. The Solicitor ID control is on the form and it
> >updates as I scroll though the Contacts. But the Solicitor's name field (the
> >dlookup) doesn't. It always shows the solicitor with Solicitor ID 1.
> >
> >> >In an Access 2003 database, I have a form, Contacts, based on a Contacts
> >> >table that includes potential donors and the Solicitor ID of their assigned
> >[quoted text clipped - 26 lines]
> >> This does assume that there is a control named [Soliciter ID] on the form,
> >> which contains the desired ID.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201005/1
>
> .
>
From: Wordwonderor on 24 May 2010 11:19
I used the combo box but not sure how it works. I'd still like to know why
the DLookup which seems more direct didn't.

The forms record source is simply the Contacts table. The Solicior ID is a
number field in the Contacts Table and a autonumber in the Solicitors table.

"John W. Vinson" wrote:

> On Fri, 14 May 2010 08:42:01 -0700, Wordwonderor
> <Wordwonderor(a)discussions.microsoft.com> wrote:
>
> >Thank you, but it didn't help. The Solicitor ID control is on the form and it
> >updates as I scroll though the Contacts. But the Solicitor's name field (the
> >dlookup) doesn't. It always shows the solicitor with Solicitor ID 1.
>
> Please post the SQL view of the form's Recordsource, and that of the combo
> box's Rowsource. Also indicate the datatype of the SolicitorID.
>
> I'd be inclined just to have a combo box bound to SolicitorID but displaying
> the solicitor name, rather than having any DLookUp or separate control; is
> there some reason you have chosen not to do so?
> --
>
> John W. Vinson [MVP]
> .
>
From: John W. Vinson on 26 May 2010 16:26
On Mon, 24 May 2010 08:19:01 -0700, Wordwonderor
<Wordwonderor(a)discussions.microsoft.com> wrote:

I'll be glad to try to help, but you'll need to help me do so: plsese post
your form's Recordsource, the combo box's Rowsource, and the datatype of the
solicoitor ID. I can't see them from here, and only that information will
enable me to reply.

>I used the combo box but not sure how it works. I'd still like to know why
>the DLookup which seems more direct didn't.
>
>The forms record source is simply the Contacts table. The Solicior ID is a
>number field in the Contacts Table and a autonumber in the Solicitors table.
>
>"John W. Vinson" wrote:
>
>> On Fri, 14 May 2010 08:42:01 -0700, Wordwonderor
>> <Wordwonderor(a)discussions.microsoft.com> wrote:
>>
>> >Thank you, but it didn't help. The Solicitor ID control is on the form and it
>> >updates as I scroll though the Contacts. But the Solicitor's name field (the
>> >dlookup) doesn't. It always shows the solicitor with Solicitor ID 1.
>>
>> Please post the SQL view of the form's Recordsource, and that of the combo
>> box's Rowsource. Also indicate the datatype of the SolicitorID.
>>
>> I'd be inclined just to have a combo box bound to SolicitorID but displaying
>> the solicitor name, rather than having any DLookUp or separate control; is
>> there some reason you have chosen not to do so?
>> --
>>
>> John W. Vinson [MVP]
>> .
>>
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2 3
Prev: Need a button to print 5 copies
Next: Sending a link for a form to the desktop - Access 2007