Disappearing Controls

[Guest]

When setting the record source of my form to a query the controls dissapear
in form view, but when changing to record source to nothing or a table they
come back...any idea why and how to fix this?

 

[John Vinson]

When setting the record source of my form to a query the controls dissapear
in form view, but when changing to record source to nothing or a table they
come back...any idea why and how to fix this?

This will happen if two conditions are both true: 1. The Query doesn't
return any records (so you can't see existing records) and 2. it's not
updateable (so you can't see the blank new record).

If you want to see and edit existing records, use an updateable query
that actually returns some data!

Normally, if you are trying to base a Form on two or more tables, it's
simpler to use a Form for the "one" side table and one or more
Subforms for the "many".

John W. Vinson[MVP]