View Single Post
  #3  
Old May 30th, 2010, 07:51 PM posted to microsoft.public.access
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default open form with no data

Hi Pierre,

Add code to the open event of the form that opens the form to a new record.
Your form will then be blank. Then when you choose a record ftom the
combobox, the form will display that record.

Steve




"Pierkes" wrote in message
...
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!
Pierre