Two text fields are not transferring, even with a simple query instead
of written code, between two tables with identical formatting.

I have 2 temp tables, one for adding a record, a second for reviewing
all the updated records once the added record is inserted.

When I am in the add record form, the temp table accepts data entry
for all fields. I can go into the table and see that all fields are
taking the correct data.

When I run a query to insert that record from the add record temp
table, it doesn't transfer 2 text fields. Everything else transfers,
but not those 2 fields.

Please, I need ideas on what could be causing this. What could be the
problem?

The query works outside of the form. If I put data in those fields, it
transfers if I run the query independently.

It must be a setting, or something. I can't figure it out and I can't
find a similar situation on line. PLEASE HELP!

ANY ideas, even bad ones, are welcome. Again, PLEASE.

-Aaron

Have you made sure that the record is saved before you attempt the transfer?

Are you sure that the controls on the form are bound to the fields that you
expect to transfer? What is the control source of the two controls that
display the data that is not being transferred.

Hard to trouble shoot what we can't see. You might consider posting your code.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 6/10/2011 2:24 PM, Aaron wrote:
> Two text fields are not transferring, even with a simple query instead
> of written code, between two tables with identical formatting.
>
> I have 2 temp tables, one for adding a record, a second for reviewing
> all the updated records once the added record is inserted.
>
> When I am in the add record form, the temp table accepts data entry
> for all fields. I can go into the table and see that all fields are
> taking the correct data.
>
> When I run a query to insert that record from the add record temp
> table, it doesn't transfer 2 text fields. Everything else transfers,
> but not those 2 fields.
>
> Please, I need ideas on what could be causing this. What could be the
> problem?
>
> The query works outside of the form. If I put data in those fields, it
> transfers if I run the query independently.
>
> It must be a setting, or something. I can't figure it out and I can't
> find a similar situation on line. PLEASE HELP!
>
> ANY ideas, even bad ones, are welcome. Again, PLEASE.
>
> -Aaron
>

On Fri, 10 Jun 2011 11:24:32 -0700 (PDT), Aaron <(E-Mail Removed)> wrote:

>Two text fields are not transferring, even with a simple query instead
>of written code, between two tables with identical formatting.
>
>I have 2 temp tables, one for adding a record, a second for reviewing
>all the updated records once the added record is inserted.
>
>When I am in the add record form, the temp table accepts data entry
>for all fields. I can go into the table and see that all fields are
>taking the correct data.
>
>When I run a query to insert that record from the add record temp
>table, it doesn't transfer 2 text fields. Everything else transfers,
>but not those 2 fields.
>
>Please, I need ideas on what could be causing this. What could be the
>problem?
>
>The query works outside of the form. If I put data in those fields, it
>transfers if I run the query independently.
>
>It must be a setting, or something. I can't figure it out and I can't
>find a similar situation on line. PLEASE HELP!
>
>ANY ideas, even bad ones, are welcome. Again, PLEASE.
>
>-Aaron

Please post the SQL of your code and the code that runs your query. We can't
see it from here.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

On Jun 10, 3:03*pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Fri, 10 Jun 2011 11:24:32 -0700 (PDT), Aaron <aaron...@msn.com> wrote:
> >Two text fields are not transferring, even with a simple query instead
> >of written code, between two tables with identical formatting.
>
> >I have 2 temp tables, one for adding a record, a second for reviewing
> >all the updated records once the added record is inserted.
>
> >When I am in the add record form, the temp table accepts data entry
> >for all fields. I can go into the table and see that all fields are
> >taking the correct data.
>
> >When I run a query to insert that record from the add record temp
> >table, it doesn't transfer 2 text fields. Everything else transfers,
> >but not those 2 fields.
>
> >Please, I need ideas on what could be causing this. What could be the
> >problem?
>
> >The query works outside of the form. If I put data in those fields, it
> >transfers if I run the query independently.
>
> >It must be a setting, or something. I can't figure it out and I can't
> >find a similar situation on line. PLEASE HELP!
>
> >ANY ideas, even bad ones, are welcome. Again, PLEASE.
>
> >-Aaron
>
> Please post the SQL of your code and the code that runs your query. We can't
> see it from here.

Just noticed you guys responded very quickly, thank you for that as
well! I didn't expect a reply on the same day so I didn't check back
here. I have posted the code now...I hope it contains something
helpful.

-Aaron