New DLookUp problem!

[Niklas Östergren]

Hi again!

I don´t seems to get along with DLookUp today ;-(

Now I try this one (see below) but get Mish match problem.

Me.txtPhoneHome = DLookup("[tblPhoneNumber]![PhoneNo]",
"[tblPhoneNumber]", "[fkTypeOfPlaceID]=" & intPhoneTypeHomeID And
"[fkPersonID]=" & intPhoneTypeHomeID )

If I run almoste the same expression (see below) in the direct window but
change the <intPhoneTypeHomeID> and <intPhoneTypeHomeID > to numbers
instead, like this:

DLookup("[tblPhoneNumber]![PhoneNo]", "[tblPhoneNumber]",
"[fkTypeOfPlaceID]=1 And [fkPersonID]= 3")

Then I get the answer I want!

Any idéas???

TIA!

// Niklas

 

[Rick Brandt]

Hi again!

I don´t seems to get along with DLookUp today ;-(

Now I try this one (see below) but get Mish match problem.

Me.txtPhoneHome = DLookup("[tblPhoneNumber]![PhoneNo]",
"[tblPhoneNumber]", "[fkTypeOfPlaceID]=" & intPhoneTypeHomeID And
"[fkPersonID]=" & intPhoneTypeHomeID )

You don't need the table qualifier in argument 1 because that is already
supplied by argument 2. Also, your "And" is outside the quotes and needs to be
inside them.

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID" & " And [fkPersonID]=" & intPhoneTypeHomeID & "")

 

[Niklas Östergren]

Hmm!

I tryed that but got some error:

"Expected: <various>!
....An expected part of the syntax was not found.

And ("&") is marked in the part (intPhoneTypeHomeID "&" And [fkPersonID]).

Any ideas?

Thanks a lot for taking time!

// Niklas

Hi again!

I don´t seems to get along with DLookUp today ;-(

Now I try this one (see below) but get Mish match problem.

Me.txtPhoneHome = DLookup("[tblPhoneNumber]![PhoneNo]",
"[tblPhoneNumber]", "[fkTypeOfPlaceID]=" & intPhoneTypeHomeID And
"[fkPersonID]=" & intPhoneTypeHomeID )

You don't need the table qualifier in argument 1 because that is already
supplied by argument 2. Also, your "And" is outside the quotes and needs to be
inside them.

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID" & " And [fkPersonID]=" & intPhoneTypeHomeID & "")

 

[Dave]

Try this

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID & " And [fkPersonID]=" & intPhoneTypeHomeID)

Hmm!

I tryed that but got some error:

"Expected: <various>!
...An expected part of the syntax was not found.

And ("&") is marked in the part (intPhoneTypeHomeID "&" And [fkPersonID]).

Any ideas?

Thanks a lot for taking time!

// Niklas

Hi again!

I don´t seems to get along with DLookUp today ;-(

Now I try this one (see below) but get Mish match problem.

Me.txtPhoneHome = DLookup("[tblPhoneNumber]![PhoneNo]",
"[tblPhoneNumber]", "[fkTypeOfPlaceID]=" & intPhoneTypeHomeID And
"[fkPersonID]=" & intPhoneTypeHomeID )

You don't need the table qualifier in argument 1 because that is already
supplied by argument 2. Also, your "And" is outside the quotes and

needs
to be

inside them.

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID" & " And [fkPersonID]=" & intPhoneTypeHomeID & "")

 

[Niklas Östergren]

Thanks a lot Dave!

It worked!

// Niklas

Try this

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID & " And [fkPersonID]=" & intPhoneTypeHomeID)

Hmm!

I tryed that but got some error:

"Expected: <various>!
...An expected part of the syntax was not found.

And ("&") is marked in the part (intPhoneTypeHomeID "&" And [fkPersonID]).

Any ideas?

Thanks a lot for taking time!

// Niklas

Hi again!

I don´t seems to get along with DLookUp today ;-(

Now I try this one (see below) but get Mish match problem.

Me.txtPhoneHome = DLookup("[tblPhoneNumber]![PhoneNo]",
"[tblPhoneNumber]", "[fkTypeOfPlaceID]=" & intPhoneTypeHomeID And
"[fkPersonID]=" & intPhoneTypeHomeID )

You don't need the table qualifier in argument 1 because that is already
supplied by argument 2. Also, your "And" is outside the quotes and

needs
to be

inside them.

DLookup("[PhoneNo]","[tblPhoneNumber]", "[fkTypeOfPlaceID]=" &
intPhoneTypeHomeID" & " And [fkPersonID]=" & intPhoneTypeHomeID & "")