Text box not displaying look up value.

[Will]

I have a form that uses a data connection to a SQL server that just receives
data. The data is id number, name, and description.

The form is supposed to pull up the name and description according to what
id# is entered. Every time I run the form and enter the id# nothing comes
back.

On the same form I also have a list box that pulls other data back using the
same id# and that works fine.

I am not sure where else I have to check to get the text box populated. Any
help would be great. Thanks.

 

[S.Y.M. Wong-A-Ton]

Did you already double-check the filter you're using? And if you're using a
browser form, you could try setting the "Postback settings" to "Always" on
the "Browser forms" tab of the #id field and see whether that helps.

 

[Will]

Thanks for the reply. I did check my filter to ensure that it isn't limiting
anything off. My filter just says display "@name where @empid = empid". I
created a form that does the same thing before and it works. The only
difference between the two different forms is that that table they pull data
from. One working form pulls data from a table with no PK or FK. The form
that does not work pulls from a table that does have a PK.

Also I know that it is getting data back because if I create a list box and
tell the list box to display information it works fine.

 

[S.Y.M. Wong-A-Ton]

I tried out your theory about the PK on an Access database, and it works fine
for me without a PK. When I get a chance, I'll try it out on a SQL Server
database (don't have one immediately available right now).

To confirm, are you on IP03 or IP07? If IP07, are you using browser forms?