Clear entries in a tab on a form

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hello -

I have a form with tabs on it. The one tab is for billing information and
includes a field for "Billing Date" and fields for Billing Descriptions.

What I would like to do is have a button that when clicked will clear only
the fields on that specific tab to allow me to make additional entries, but
for a new date.

When I try to go to "New Record", etc..., it takes me to the next person in
the list. What I really need is to have clear fields on just the Billing
Information tab and for that specific person; not the next one on the list.

I am not an expert at Access, so if you could point me in the right
direction without using code and as easily as possible, I would greatly
appreciate it.

Thanks in advance for your help!
 
Hello -

I have a form with tabs on it. The one tab is for billing information and
includes a field for "Billing Date" and fields for Billing Descriptions.

What I would like to do is have a button that when clicked will clear only
the fields on that specific tab to allow me to make additional entries, but
for a new date.

When I try to go to "New Record", etc..., it takes me to the next person in
the list. What I really need is to have clear fields on just the Billing
Information tab and for that specific person; not the next one on the list.

I am not an expert at Access, so if you could point me in the right
direction without using code and as easily as possible, I would greatly
appreciate it.

Thanks in advance for your help!
Click to expand...

The first thing to realize is that your Form is *just a window*.

There is no data stored in the Form.
There is no "record" in the form.
A Tab on a form is just a way to visually arrange controls to save screen
space. It has no logical connection to the data.

The data is stored in your Tables, and ONLY in the tables.

So... what is your form's Recordsource (it will usually be the name of the
table or query where the data is stored)? What tables do you have? How are
they related? Are you storing the personal information and the billing
information in the same table (you should have two tables)? Does your Tab have
a Subform on it (it probably should)?
 
Ann said:
Hello -

I have a form with tabs on it. The one tab is for billing information and
includes a field for "Billing Date" and fields for Billing Descriptions.

What I would like to do is have a button that when clicked will clear only
the fields on that specific tab to allow me to make additional entries,
but
for a new date.

When I try to go to "New Record", etc..., it takes me to the next person
in
the list. What I really need is to have clear fields on just the Billing
Information tab and for that specific person; not the next one on the
list.

I am not an expert at Access, so if you could point me in the right
direction without using code and as easily as possible, I would greatly
appreciate it.

Thanks in advance for your help!
Click to expand...
 
Back
Top