Adding a queried field into a form

  • Thread starter Thread starter Tellis2112
  • Start date Start date
T

Tellis2112

I have a form that I use to enter client information. I have a query
elsewhere that gives me a balance for the client. I am looking to add a
field into the entry form that displays the results of the query for that
client.
I tried using dlookup, but keep getting an error on it.
 
You should have posted the DlookUp so we could correct it.
The syntax for Dlookup is as below

=DLookUp("[FieldName]","Client Table","[FieldInTable] = " & [ClientID])
 
Well, you were right that the format was incorrect. I ommited the " &. I'm
still not able to get it to work, though. Here is the dlookup statement:

=DLookUp("[CurrentStatus]","BET_Status_01-LastAction3","[Prosp] = " &
[ProspectID] )

It's actually not the balance, but the last status that I'm trying to
display. I just figured that balance was easier to explain than status when
I created the post.

Thank again.


Dennis said:
You should have posted the DlookUp so we could correct it.
The syntax for Dlookup is as below

=DLookUp("[FieldName]","Client Table","[FieldInTable] = " & [ClientID])

Tellis2112 said:
I have a form that I use to enter client information. I have a query
elsewhere that gives me a balance for the client. I am looking to add a
field into the entry form that displays the results of the query for that
client.
I tried using dlookup, but keep getting an error on it.
Click to expand...
Click to expand...
 
Back
Top