Combo box (missing data)

Novice1

Registered User.
Local time
Yesterday, 20:05
Joined
Mar 9, 2004
Messages
385
I have a form with an option group (different queries of the form). Everything works fine. I have a TechID (combo box). The number field is linked to another table (linked to col 1 (number); but shows col 2 (text)). Column count: 2; Column width: 0"; 1" Again, no problem.

The problem occurs when calling a different query on the form. The first record and only the first record, with each query doesn't show the data. (1) I deleted the field from the table, then recreated it (same problem). (2) I tried recreating the queries (same problem). The data (number) is being stored. The text simply isn't showing, on the first record in the query.

This is bizarre to me. I don't know what else to do???
 
Found the problem. Designer placed a null statement where it didn't belong.
 

Users who are viewing this thread

Back
Top Bottom