Button to add data in multiple tabs

M

Mike

I have a form that contains 6 tabs. Each tab (table) has a relationship with
one another. Is there a way where I can place an "Add New" record button
that clears out all fields in the 6 tabs?
 
J

John W. Vinson

I have a form that contains 6 tabs. Each tab (table) has a relationship with
one another. Is there a way where I can place an "Add New" record button
that clears out all fields in the 6 tabs?
Click to expand...

You're confusing levels here.

A Tab is just a way of organizing screen space.
A Form is a window for updating data in tables.

What is the recordsource of your mainform? Do you have six Subforms on these
tabs based on six tables? Do you want to permanently and irrevokably remove
all previously entered data in the six tables whenever you add a new record to
the mainform - and if so, *why*???
 
M

Mike

Hey John, thanks for taking the time to read my request. Yes it seems a
little confusing but I think its the way I'm explaining it. I have a form
that contains pages rather than tabs. The main form is just a blank form and
I was able to place "pages" on that blank form. 6 pages to be exact. I was
calling it tabs because you would click on the tab which is located at the
top of the page/form to get to the form needed. Similiar to how Internet
Explorer is using the tabbed browsing. Each page contains a different form
in it. And what I'm trying to do is update each form/page based on the
record information.

Basically I have a case number that I input into the first form along with
additonal info. Once I'm done inputting info into that form, I want that
case number to reflect the rest of information being inputted into each
page/form. But when I'm done and I want to add another case number I go back
to the first page/form and I want to be able to press a button that says "Add
New Record" but when this selected I would like all the other pages/forms to
clear out for the new data to be entered. I hope this is making sense. If
not please feel free to school me. Thanks!
 
J

John W. Vinson

Basically I have a case number that I input into the first form along with
additonal info. Once I'm done inputting info into that form, I want that
case number to reflect the rest of information being inputted into each
page/form. But when I'm done and I want to add another case number I go back
to the first page/form and I want to be able to press a button that says "Add
New Record" but when this selected I would like all the other pages/forms to
clear out for the new data to be entered. I hope this is making sense. If
not please feel free to school me. Thanks!
Click to expand...

As my friend Tom likes to say, "It all depends on the data".

What are your Tables? What is each table's Primary Key? How are the tables
related?

From the sound of it, you should consider basing the mainform on a table of
Cases, with the six other forms as Subforms, using the CaseNumber as the
master/child link field. But since it's not clear to me how your data is
structured I'm not sure that will address the issue!
 
Top