open form with no data

P

Pierkes

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
 
J

Jörn Bosse

Am 30.05.2010 19:50, schrieb Pierkes:
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
Hi,

you can try something like this. Create a record without any
information. That means with no entries, except of one column. For
example a 0 in a field with integer-values. When you open the Form, you
will only see that 0 and nothing else. That is the most easy way to
solve this problem, i guess.

Greetings, Jörn
 
T

Tom Wickerath

Hi Pierre,
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) ?

Yes. Simply add a WHERE 1=0 clause to the form's recordsource (saved query
or SQL statement). You will need to reassign the form's recordsource in the
AfterUpdate procedure for your combo box. I have an example that uses a main
search form with a subform, but is is a bit more complex that simply using a
combo box. But, it does reassign the recordsource for the subform with each
query run. You might want to have a look, here:

http://www.accessmvp.com/TWickerath/downloads/elements.zip

http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
S

Steve

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
(e-mail address removed)
 
R

Rick Brandt

Pierkes said:
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.
 
T

Tom Wickerath

No, Steve, the form will not display the record of interest. The reason is
that the recordset contains no existing records. Try it out if you don't
believe me.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
R

Rick Brandt

Pierkes said:
Hi Rick,

I tried to reply to the group earlier but didn't see it appearing so
here's another go...

Thanks for your code, it works !

However, i do not use the DoCmd.OpenForm "FormName",,,"1 = 0" to open the
form but instead, to get the form to open in a subform, i use ;

SubFormArea.SourceObject = "Houses"

Any idea on how to adjest this code so it opens with a blank sheet ?
Thanks in advance,

Well, that does change the parameters of the question quite a bit. You
could try...

SubFormArea.SourceObject = "Houses"
SubFormArea.Form.Filter = "1 = 0"
SubFormArea.Form.FilterOn = True

....but I'm not sure if that would first "blink" on a record before the
filter is applied.

If you are going to use a subform then you might be best to put the ComboBox
in the main form and use the MasterLink and ChildLink properties to do the
filtering. In that case as long as the main form starts out with a ComboBox
entry that has no match in the subform then you should get a blank subform
until you change it.
 
D

Daniel

On all of the database's that I have created, in the forms property sheet
data section (when the form is in design view), I set the Data Entry to Yes.

Then in the vb, before the code for the combo box runs, simply insert Date
Entry = False.

Has worked fine for me from Access 97, right up to 2007.

Daniel
 
P

Pierkes

Hi Rick,

Thanks for your code, it works !

However, i do not use the DoCmd.OpenForm "FormName",,,"1 = 0" to open the
form but instead, to get the form to open in a subform, i use ;

SubFormArea.SourceObject = "Houses"

Any idea on how to adjest this code so it opens with a blank sheet ?
Thanks in advance,
Pierre
 
P

Pierkes

Hi Rick,

I tried to reply to the group earlier but didn't see it appearing so here's
another go...

Thanks for your code, it works !

However, i do not use the DoCmd.OpenForm "FormName",,,"1 = 0" to open the
form but instead, to get the form to open in a subform, i use ;

SubFormArea.SourceObject = "Houses"

Any idea on how to adjest this code so it opens with a blank sheet ?
Thanks in advance,
Pierre
 
P

Pierkes

Hi Rick,

Tried your code...

SubFormArea.SourceObject = "Houses"
SubFormArea.Form.Filter = "1 = 0"
SubFormArea.Form.FilterOn = True

What happened was;

1 form loaded blank (which is good)
2 the form "blinked" (which is not good...)
3 using the combobox on the form does not result in changing the data on the
form anymore (because the filter is on?)

Anuy ideas?
thanks,
Pierre
 
D

David W. Fenton

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) ?

Use a recordsource like this, where "MyTable" is the smallest table
in your application, and the fieldnames are the fields controls on
the form are bound to:

SELECT TOP 1 Null As Field1, Null As Field2, Null As Field3
FROM MyTable

This gives you a single blank record that is uneditable. You would
then change the recordsource in the code that does the search.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top