Table lookup row source

[Pwyd]

I have a table that used to work fine -- its a table that uses as its row
source a query that runs on a table linked from another database. At some
point last week, it stopped working. Right now, the row source is blank. If
i change the row source to the table, or a query of the table, and save it,
then page over, it looks fine. However when i close the database and reopen
it, the source is blank again whats the problem here?

 

[George]

Something doesn't add up here.

Tables don't have row sources.

Are you talking about a lookup field in a table perhaps? Or maybe a
subdatasheet?

And what do you mean by "page over"?

Help us help you by providing more information.

 

[Pwyd]

Yes, the lookup setting on the table.

by page over, i mean alt >


The row source shows property on the lookup setting on the table its linked
to, in its originating database is fine, and works fine. However on the
database its linked to, the row source is now blank (i really don't know why
it went blank either. literally nothing's changed on it for over 3 months
other than adding records.). Filling it in with the proper query or table
(doesn't seem ot matter which) lets it work while i have it open for that
session. Saving it does nothing. Upon closing and reopening it, its blank
again I don't even have to close the database to get that effect. If i
simply close the table and reopen it from the database objects listing, its
blank again

 

[Pwyd]

Okay, so there's some more info to this: if i unlink the table and relink
it, it will carry over the row source it has from the original. However, any
attempts to modify it in its original location or its linked location cause
it to go blank. In addition, its now showing an option that doesn't show up
in the query its using as its row source: the query shows two text strings.
The table's lookup, when you make a new record, shows the two text strings,
and the number "0" as one of the options.

 

[Pwyd]

Here's some more information: any time i try to build a query based on the
linked table, it counts the correct number of rows, but they too are all
blank, and the drop-down that would normally let me select one of the options
from the lookup that its based on, is also blank. I have my odbc settings to
not time out ever. What else could be causing this?