View Single Post
  #4  
Old May 30th, 2010, 07:56 PM posted to microsoft.public.access
Rick Brandt
external usenet poster
 
Posts: 4,354
Default open form with no data

Pierkes wrote:

Hi,

I have a form on which i present al lot of data from a database.
On the form is a comobox which i use to select the right record en present
the data of this record on the form.

When i open de form, de combobox is empty (which is good !) but the rest
of the form is already filled with the data of a record in the database
(which is not good). When i choose a record for the combobox, the form is
filled with the data of that particular record (which is good).

So the only problem i have is on opening the form. Is it possible to open
the form without it being filled with data of a certain record (so is see
a blank form) ?

Help will be much appreciated!


Just open the form with a WHERE argument that has no records returned.

DoCmd.OpenForm "FormName",,,"1 = 0"

If you are using the bookmark method to show records with your ComboBox
change that to applying a filter for the desired record.

No need to mess with DataEntry mode or change Recordsets.