If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
no existing records shown on a continious form
Working on a continious form I'm entering some records
into a table. But, after closing this form and re-opening it I cannot see these previously entered records despite they exist in the table. Could anybody clarify why it's happened? Thanks |
#2
|
|||
|
|||
no existing records shown on a continious form
"Alex" wrote in message
... Working on a continious form I'm entering some records into a table. But, after closing this form and re-opening it I cannot see these previously entered records despite they exist in the table. Could anybody clarify why it's happened? Thanks Among the possibilities a 1. The form's Data Entry property is set to True. 2. The form is based on a query with criteria that exclude the records you're adding. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup, not by e-mail) |
#3
|
|||
|
|||
no existing records shown on a continious form
On Fri, 13 Aug 2004 14:50:27 -0700, "Alex"
wrote: Working on a continious form I'm entering some records into a table. But, after closing this form and re-opening it I cannot see these previously entered records despite they exist in the table. Could anybody clarify why it's happened? It sounds like you have the form set to Data Entry. In design mode check the forms properties window on the Data tab and see if the Data Entry property is set to Yes. - Jim |
#4
|
|||
|
|||
no existing records shown on a continious form
Hi, Alex.
Inability to see new records after closing, then re-opening, the form, is caused either by your Form's "Data Entry" Property being set to "Yes" or by your new records being filtered out of the Form's Recordset. First, check the Form's "Data Entry" Property (on the Properties "Data" tab) and ensure that the "Data Entry" Property is set to "No." If it already is, then check the Form's Record Source Property (also on the Properties "Data" tab) to see whether it is based upon a saved query whose criteria excludes your new records or whether there's a SQL statement that also excludes your new records. If the Record Source Property isn't the culprit, look at the VBA code to find a "Filter = ..." for this Form (the code doesn't actually have to be in the Form's module, since your Form can be referenced elsewhere) and a "FilterOn = True" somewhere that has criteria that excludes your new records. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. "Alex" wrote in message ... Working on a continious form I'm entering some records into a table. But, after closing this form and re-opening it I cannot see these previously entered records despite they exist in the table. Could anybody clarify why it's happened? Thanks |
#5
|
|||
|
|||
no existing records shown on a continious form
Thanks a lot, everybody.
The Data Entry was set to Yes. Regards, Alex -----Original Message----- Working on a continious form I'm entering some records into a table. But, after closing this form and re-opening it I cannot see these previously entered records despite they exist in the table. Could anybody clarify why it's happened? Thanks . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
Form records out of order | Jason Kneip | Using Forms | 7 | August 6th, 2004 02:19 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Form doesn't pull up records from table | Ed Burns | Using Forms | 3 | June 8th, 2004 07:41 PM |
Number of Records shown from Filter Mode | Tien Mai | Worksheet Functions | 1 | April 26th, 2004 10:06 PM |