Subforms not Displaying

[Ryan Langton]

I recently converted an application from an .mdb to a .mdb with linked
tables (SQL Server). On my main form, I have several subforms. These
subforms show up fine when I'm dealing with existing records, however when I
add a new record to the form, the subforms disappear. Any ideas what could
cause this?

Thanks,
Ryan

 

[Ryan Langton]

This may help. These subforms all consist of a single combo box. When I
open the subform in a new window and switch to Form View (rather than Design
View), I get the blank grey background - which would make it appear that the
subforms are "disappeared" on my main form. I don't know what in the
conversion could have caused the problem though.

 

[Ryan Langton]

Just an FYI incase anybody else has this problem.

What was happening was that I could not add new records to my subforms, so
it was showing no detail records (was not showing the add new * line). The
reason why I could not add records was because the subforms record source
did not have a primary key. I changed the record source query to add in a
primary key from one of the tables and it works fine now. SQL is picky
about primary keys.