Help With CheckBox

  • Thread starter Thread starter billy_pit
  • Start date Start date
B

billy_pit

Hi,
My Project is in MS Access.
In that I am using one form for Shipping Entry.
In That I put One Check Box.
Now If Shipping Address and Billing Address Are same than I click on
that CheckBox.So It will automaticaly enter whatever address entered
in Billing Address into Shipping Address.Now uptill this point
everything working fine.

Now I want this thing.
When I click again on that CheckBox Than it will automaticaly Delete
Shipping Address.So If I want to enter Different Shipping Address I
can.And If I clicked again after that than it will again automaticaly
enter the Billing Address in Shipping Address.But I don't know how to
do it?

In VB we can use (I don't know proper code for VB) something like this
if(CheckBox1.checked=true) then
xyz
else
xyz

Like I want to know how can I check that CheckBox Is Clicked before or
not.
Thanks.
 
Hi,
My Project is in MS Access.
In that I am using one form for Shipping Entry.
In That I put One Check Box.
Now If Shipping Address and Billing Address Are same than I click on
that CheckBox.So It will automaticaly enter whatever address entered
in Billing Address into Shipping Address.Now uptill this point
everything working fine.

Now I want this thing.
When I click again on that CheckBox Than it will automaticaly Delete
Shipping Address.So If I want to enter Different Shipping Address I
can.And If I clicked again after that than it will again automaticaly
enter the Billing Address in Shipping Address.But I don't know how to
do it?

In VB we can use (I don't know proper code for VB) something like this
if(CheckBox1.checked=true) then
xyz
else
xyz

Like I want to know how can I check that CheckBox Is Clicked before or
not.
Thanks.
Click to expand...

Use the After Update event of the Checkbox. It will fire only if your
user changes the checkmark.

If CheckBox1 = True then
'copy in all your Shipping values
Else
'clear all your Shipping values
End If

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
billy_pit said:
Hi,
My Project is in MS Access.
In that I am using one form for Shipping Entry.
In That I put One Check Box.
Now If Shipping Address and Billing Address Are same than I click on
that CheckBox.So It will automaticaly enter whatever address entered
in Billing Address into Shipping Address.Now uptill this point
everything working fine.

Now I want this thing.
When I click again on that CheckBox Than it will automaticaly Delete
Shipping Address.So If I want to enter Different Shipping Address I
can.And If I clicked again after that than it will again automaticaly
enter the Billing Address in Shipping Address.But I don't know how to
do it?

In VB we can use (I don't know proper code for VB) something like this
if(CheckBox1.checked=true) then
xyz
else
xyz

Like I want to know how can I check that CheckBox Is Clicked before or
not.
Thanks.
Click to expand...

Perhaps you could try this:
In the After Update Event of the CheckBox have
If Me.YourCheckBox = True Then
'put in code to fill in Shipping Data
end If
If Me.YourCheckBox = False Then
'code to delete shipping data in box
End if

Evi
 
I tried this one and its working.
In the After Update Event of the CheckBox have
If Me.YourCheckBox = -1 Then
'put in code to fill in Shipping Data
Else
'code to delete shipping data in box
End if
Click to expand...

Thanks for ur reply.
 
Back
Top