disappearing records

J

jman

I cannot access records from my table after they have been entered via a
form. I can enter the information in the form and when I click the preview
report button (which I have coded to only show the current record) the
information is correct. When I close the form and reopen it, the entry is
gone and everything is blank. The same situation occurs when I open the
reports. The information has been written into the table correctly, but I
cannot access it via a form or a report after I close the form I entered the
information into.
 
J

jman

After investigating this further, I have determined that this problem only
occurs when you access the form using the switchboard. Does anyone know why
this is happening? Although I can now access my records by going to the main
layout, I would like to be able to access them correctly via the switchboard.
 
J

Joan Wild

When you created the switchboard, you likely chose to 'open form and add
records' rather than 'open form and edit records'. The former will only
allow you to add, so you won't see any existing records.

Simple way to change it: Open the Switchboad Items table, and change the
Command for that Item from 2 to 3.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top