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
|
|||
|
|||
Open form with selected records - New to Access
I am trying to open my form from a splashscreen and only show records that
have a blank date field. My form always opens without any records. I have at least 30 in the table. I tried opening from a query that I use to list these records on a report but then I cannot add new records. |
#2
|
|||
|
|||
Open form with selected records - New to Access
Open the form in design view and check its properties. If the form opens
without records, it may have the Data Entry property set to Yes (providing a form for entering new data, but not showing existing). Another approach, and one that saves loading all the available records "behind the form", would be to put an unbound combo box in the header of the form. Make the source of that combo box the list of available records (just few enough fields for a human to be able to identify which one they want). In the combo box's AfterUpdate event, requery the form. Base the form's source on a query that looks to the combo box to get the recordID parameter. Regards Jeff Boyce Microsoft Office/Access MVP "bikemrh" wrote in message ... I am trying to open my form from a splashscreen and only show records that have a blank date field. My form always opens without any records. I have at least 30 in the table. I tried opening from a query that I use to list these records on a report but then I cannot add new records. |
#3
|
|||
|
|||
Open form with selected records - New to Access
On Mon, 10 Sep 2007 12:38:01 -0700, bikemrh
wrote: I am trying to open my form from a splashscreen and only show records that have a blank date field. My form always opens without any records. I have at least 30 in the table. Turn off the form's Data Entry property; that's what it does - lets you enter new records but does not display old ones. I tried opening from a query that I use to list these records on a report but then I cannot add new records. Correct the error in the query, then; most queries are updateable, some aren't. Or create a new query - select your table, create a new query based on it, and change the criterion on the date field to IS NULL Save the query and base your form on it. John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|