Tickbox to replicate data

[DeanRowe]

Hi,

I'm currently using Access 2000 and I'm having trouble with one of my forms.

I have two sets of fields, one for "billing address" and another for "delivery address".

I want to have a "delivery same as billing address" tick box on the form so when it's ticked the data thats been entered in the billing fields are automatically replicated in the delivery fields. However I'm having a lot of trouble....

I've added a "Yes/No" field to my table, and added the tickbox to my form, however on the form its default value is set to yes/ticked - and I can't figure out how to have it set to no/unticked - I've looked at the properties in both the table and form settings but can't see how to alter this.

I use lots of double click events on my form to calculate figures, and I have been going into the "properties" > "event" > "On Dbl Click" to begin programming the code - however on the tickbox properties the "event" section is completely blank - has anyone ever encountered this before? I'm unsure how to go about programming the form to replicate the billing fields into the delivery fields when the box is ticked.

Any help or advice would be greatly appreciated.
Thank you for your time.
Kind Regards

Dean Rowe

 

[wazz]

dont' duplicate the data, just use your chkbox to find out if the addresses are the same then DLookup the address when required.

i can set the default value of a check box in the table and the form (yes/no, true/false) and all the main events are available incl. click and dblclk...

 

[CEH]

This is one place I would say YES to duplicate data. For the simple reason it can start as duplicate but over time change...(many other reason also...but I'll stop with that one) I use a similar function having a "Billing Address" and a "Job site" address. I use a button called "Same" to add the second address when it is the same........

Private Sub cmdSame_Click()

CustDescription = JobDescription
CustAddress = JobAddress
CustCity = JobCity
CustState = JobState
CustZip = JobZip

End Sub

Now you should be able to modify this for your checkbox....with a simple If.... then... statement.
ie... If checkboxName = True then
CustDescription = JobDescription ........ so on.

 

[GaryPanic]

I have kinda a simlar situtation and my answer to this was

i deal with brokers and clients
clients of course would be the billing and delivery address - where as broers would be the billing address but the client would be the brokers client (insured)

so
billing address and insured = two diffenet address
client same address for both


I had if broker then insured - allow over type - if client then client = insured. locked

this may not help but it was how i solved thisd problem-
not the cleanest solutin - but I only want to make accounts where i am due money- the brokers client does not own me money - but the broker does

you might want to tweak this idea

 

[Skilly]

check box problems

I have added a check box on my form where I want to place a tick if the customer has received stationary and leave if blank if he hasn't. I followed all the instructions in the help command and when I go to the view form and tick in the box it ticks all other forms also when I remove the tick they are all blank, I cant find out how to set it so that it only ticks when I want it - i followd the help info and im now spending to long on trying to figure this out - help!

 

[CEH]

Im guessing you added a checkbox to the form and did not add a field "Yes/No" to the table..........Adding it to a form only will not tie it to a record. if you add a field to your table I think this will solve your problem. (Your control source for the checkbox on the form will then need to be that field)

 

[Skilly]

Im new to this, so ill try to explain, Im in the design view of the form, on the new check box ive done a right mouse click, properties and then have the following check box options;Format, Data, event, other and all.

I went into table and added the yes/no in the objects are, this did no good.
any other tips or a link to a help page. I followed the access help to add the check box but it doesnt say how to activate it etc...?

 

[boblarson]

You need to BIND the checkbox to the table. You need to select the properties of the checkbox in the form's design mode and under controlsource click the dropdown and select the field in your table which will store the data.