Forms come in 3 "flavours":
Single Form (Displays one record at a time.)
Continuous Forms (Displays as many records as will fit in the current
window, each in its own copy of the form's detail section.)
Datasheet (Displays the form fields arranged in rows and columns like a
spreadsheet)
You need to set the form's Default View, plus you may have to specify the
view when you're using DoCmd.OpenForm
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Marylin" <(E-Mail Removed)> wrote in message
news:AA743EC3-8D22-49D6-A374-(E-Mail Removed)...
> I actually have couple of questions about Access 2003. Here they are:
>
> Does Form Views displays a single record at a time?
>
> Can you save changes that you make to a query created with the smple query
> wizard?
>
>
>
>
>