Recordsourcing

[ClearlyAnIdiot]

I used to have a problem where my form would only show 1 record of 7. After changing the record source to a table, however, it no longer shows a particular subform, instead turning up blank. Furthermore, a one-to-one relationship between this table (company) and another(company_address) shows up as #Name?. I didn't have this problem before changing the record source from some query or another that was default.

 

[JHB]

Check if all needed fields are in then table, because it seems as the field names change/ or is left out, when you go from the query to the table.

 

[ClearlyAnIdiot]

Nope, the control sources all use the correct names. And they don't all refer to the "Companies" table. As I said, there is one subform and one one-to-one relationship, and those are my prblems. Although I may simply not have understood that answer. (Sorry! I haven't used Access in months!) Also, I don't use queries, as I've mentioned.

 

[ClearlyAnIdiot]

Errr, never mind, guys. This is embarrassing, but I accidentally added a fullstop to all of the control sources out of habit. No problems here!

 

[JHB]

Errr, never mind, guys. This is embarrassing, but I accidentally added a fullstop to all of the control sources out of habit. No problems here!

Exactly what I said - "unknown" field names, good you solved it.