dlookup problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike bfd - 01 Feb 2008 00:07 GMT

i am just learning to use access and have a problem. i am trying add data
from a table to a active form.
the table is named departments
it has three columns id,department code, department discription
i have a combo603 on the active form that i am uses in the critia.
=DLookUp(" [Department discription]","[departments]","
[Departments]![Dpartment code]=" & [Combo603])

[combo603] presentas a number form the table [departments]![department code]

Reply to this Message

fredg - 01 Feb 2008 00:29 GMT

> i am just learning to use access and have a problem. i am trying add data
> from a table to a active form.
[quoted text clipped - 5 lines]
>
> [combo603] presentas a number form the table [departments]![department code]

The bound column of the Combo box is a Number datatype?
Did you check for spelling errors in your syntax?
Discription is not the same as description.
Dpartment is not the same as Department.

I have no idea of what the actual field names are.
The spelling is not important as long as it matches exactly the actual
field name.

=DLookUp("[Department description]","[departments]","
[Department code]=" & [Combo603])

Should work if the field names are spelled normally, and the datatype
of [Department code] is Number, not text.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

John W. Vinson - 01 Feb 2008 00:40 GMT

>i am just learning to use access and have a problem. i am trying add data
>from a table to a active form.

You've got it backwards.

You add data *to tables* USING forms. Forms are just windows; they do not
contain or store data.

>the table is named departments
>it has three columns id,department code, department discription
[quoted text clipped - 3 lines]
>
>[combo603] presentas a number form the table [departments]![department code]

Ok. What's happening that you don't want to happen, or not happening that you
do want to happen? You haven't stated a problem. What's the Recordsource for
the form?

If you just want to see the department description, you don't need a DLookUp
at all; put a Textbox on the form with Control Source

=[Combo603].Column(2)

to display the third (it's zero based) column of the combo box.

John W. Vinson [MVP]

Reply to this Message

Jan Staaks - 01 Feb 2008 10:50 GMT

ik kan bestanden soms niet openen bij windows mail.

> i am just learning to use access and have a problem. i am trying add data
> from a table to a active form.
[quoted text clipped - 6 lines]
> [combo603] presentas a number form the table [departments]![department
> code]

Reply to this Message