Controls on Form do not show up

[AdamP]

I created a new adp file, and after linking it to SQL 2000, I create a form. I made the form's record source one of the tables in the database. But after I switch from the form design view to Form view, all of the controls that I had created on the form disappear. What is going on here?

 

[codemech]

This has something to do with a null recordset. I have seen it many times and cannot figure out how to get the form controls to display when there are no records returned in the rowsource.

C

 

[AdamP]

That makes sense. I now have it working. Thanks!