Ana,

You have explained, somewhat, what you do but not why which still leaves a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one assume
by this statement that there is a table in database 1 that has a table with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table off to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your original
posting comes into play. What are you trying to autofill? Or was that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in database2
when I complete the form (I am thinking a "submit" command button for this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and 2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my review.
In
some cases, the analyst entered it correctly or they could have entered it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with data.
In
fact, forms don't have any data at all, tables do. Forms are bound to a
table or a query, or maybe your form is unbound? So where/how is your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append auery to
send the data to a table(s). However, that brings us to question number
two... what are the reviewed fields? Is someone checking a box once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments


.