Switchboard is not picking up table content

[RichardCP]

I have created a switchboard which provides access to blank forms as well as
access to completed forms and their data. I have discovered that one of the
switchboard buttons no longer brings up the data stored but just provides a
new form. The other buttons still work OK. What has happened? How can I
put this right?

Many thanks. Richard

 

[Jeanette Cunningham]

Hi RichardCP,
you can get a blank form if the form opens with its data entry property set
to Yes.

You can check that on the property dialog for the form, on the data tab.
If it doesn't have its data entry property set to Yes, than it is likely to
be the code on the switchboard button that is opening the form ready to add
new data instead of opening in edit mode to show the existing data.

Another possibility is that the form has lost its recordsource (by
accident)- check on the property dialog for the form that the data source is
a table or a query.

Check both the table and the query by opening them from the database window.
If either the table or the query have no data, that will cause the form to
open blank.

 

[RichardCP]

Hi Jeanette

Many thnaks for this. I'm no expert so I'm really struggling with this!
I've checked properties and it is set to Yes. How do I check the code on the
switchboard button?

Richard

 

[Jeanette Cunningham]

Leave the current button/s on the switchboard.
Put a new button and code it like this to open that form.

DoCmd.OpenForm "NameOfForm"

Does the form open as a blank form?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Not sure if I got the intended meaning from your last post.
If the form that opens blank has its Data Entry property set to Yes, that
this is causing the form to open at a blank or new record.
So if your form has Data Entry set to Yes and you want the form to open
showing its data, change the Data Entry property to No.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia