Re: Inserting Data into Existing Record

Hello, thanks for the reply, here are the answers below:

Let me get this straight, you are using TWO forms to update ONE table? Are
there any locks on the forms? (i.e. RecordLocks property) This should be set
to "No Locks".

Yes, I have one table (holding both billing and shipping info) being updated
by 2 forms. Record locks are off

Why don't you have fields for Billing info and Shipping info in one table.
You could use a Tab Control if you do not have much room.

I do have both billing and shipping info in one table. I cannot use a tab
control as it is already set up on form1 - unless there is a way to put a tab
control within a tab control?

Am I asking for the impossible? Thanks!
-gary


"Powderfinger" wrote:


"Gary Dolliver" <GaryDolliver@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1902651E-4DFB-4B6E-B9AC-1417DE39CE6B@xxxxxxxxxxxxxxxx
Thanks Jeff, and sorry for the lack of info - perhaps you can shed some
light
on making this a little easier for me... ;)

Basically, form1 is a general receiving screen (address info and generic
product info) and form2 is to gather billing information (shipping
information is collected on form1). I do not have this information on
form1
as space is limited and probably 9 out of 10 times it will not be
relavent.
Therefore, I thought a seperate form, activated by a check box on form1
(yes/no - yes opens form, no duplicates shipping info into bill to
fields),
would be able to accomodate this. Ideally, I would like to have all of
the
information in one record in table1 (I know I could do this if I seperated
the tables, billing v. shipping, but what would be the fun in that?)

I am using a field Order_ID from table1 to try and keep everything
together

Hope that helps, thanks!
-gary

Let me get this straight, you are using TWO forms to update ONE table? Are
there any locks on the forms? (i.e. RecordLocks property) This should be set
to "No Locks".

Even so that's not a good way to do it.

Why don't you have fields for Billing info and Shipping info in one table.
You could use a Tab Control if you do not have much room.. Then copy the
Shipping fields to billing when there are the same (i.e. Me.BillingAddress =
Me.ShippingAddress)



.