Switchboard

N

Nanette

How do I create a switchboard using an updated query. I was able to create
forms with all my other queries and then a switchboard for them, but I can't
create the form or switchboard on the updated one. --
Thank you, Nanette
 
V

Van T. Dinh

A SELECT Query returns a Recordset (rows) which can be used as the
RecordSource for a Form.

An UPDATE Query does not return a Recordset and therefore cannot be used as
the RecordSource for a Form.

HTH
Van T. Dinh
MVP (Access)
 
N

Nanette

Thanks. Okay so I cannot create a switchboard with an update query. Am I
correct that in order to create a switchboard using a query, you must first
create a form using the query?
 
V

Van T. Dinh

I am not sure what you meant by switchboard here. Normally, Switchboard
(whether create by the Switchboard Manager or not) means a Form being as
some sort of Menu. Usually, the Switchboard Form is unbound so there is no
need for RecordSource.

Perhaps, you should explain what you meant by "switchboard" and what you are
trying to achieve in details.
 
Top