form wont save input info

  • Thread starter Thread starter tmclaude
  • Start date Start date
T

tmclaude

I new guys so please be patient.
I made a form based on only one table(tblCustomers),
I have tabs for contact info, billing and shipping
address. When I input data, and try to close the form it
says it cant cave the data because it would make
duplicates and advises me to change the index value.
Well i changed everthing i could in the table and it still
wont save anything. This is my first project and i just
wanted to make a form like one i saw on the net. I have
no querry defined at all, i created only 1 table(no
relationship). What am i doing wrong
Thanks, TC
 
Are the contact info, billing and shipping address part of tblCustomers if
so, I believe this is your problem. You either have to put contact, billing
and shipping on the same tab or split each of these sections out into
separate tables using the primary key of the tblCustomers as the primary key
for the new tables. This will create a one to one relationship. Then you can
add these sections to a new table and link them via the primary keys.

Note: if you create a tab and list billing and shipping info you can create
a button that will copy the contents of the billing address to the shipping
address, which will speed up data entry. On the OnClick or Double click
event you just set the field from the shipping address = billing address.
Such as Me.ShippingName = BillingName
 
Back
Top