open form with null values in all fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to open my form with null values in all the fields. When I pick a
record, it can populate the fields. Alternatively, I can start entering data
and it won't populate automatically.
 
Make the form unbound (don't link it to a table or query) and specify the
record source only after a record is selected. I'm guessing that you have
another control that allows the selection of a record.
 
So I'm a bit confused. When I look at the properties of the form, I have a
record source. You're saying I should delete that??? How will it know where
to file all the bits of data I will be entering?

Trace
 
Maybe I misunderstood what you're trying to do. Your first post said that
you want to open a form with all Null values and you don't want data to
automatically populate (a table). I assumed that you have a function that
saves the data when you want it to (with an Update query or something). This
means that the form is essentially unbound (yes, it has no record source). I
also assumed that you have a combo box or something that allows the selection
of a record, at which time, you can change the record source to the a table
and record. Is this what you want to do?

Or perhaps you simply want to open the form in DataEntry mode? This will
open the form with Nulls for the sole purpose of adding new data, but the
table will be populated automatically.
So I'm a bit confused. When I look at the properties of the form, I have a
record source. You're saying I should delete that??? How will it know where
to file all the bits of data I will be entering?

Trace
Make the form unbound (don't link it to a table or query) and specify the
record source only after a record is selected. I'm guessing that you have
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
Back
Top