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.
|