Access 2003 Switchboard

[Bardia]

I created a form and entered over hundred records.
Then I created switchboard to open this form for adding additional records.
Now when I open the form via switchboard there is no record, form is empty,
but when I open the form by clicking on its name in database window all the
records are there.
Please advice

 

[strive4peace]

Hi Bardia,

your switchboard probably does this:

DoCmd.OpenForm "Formname", , , , acFormAdd

acFormAdd = 0
and this means that the form will be for adding records only ...

if this is not what you want, then do not give OpenForm this argument


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Jeff Conrad [MSFT]]

Hi Bardia,

See if this link topic on my site helps:

http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#norecords

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com