checkbox values

[lee123]

i have on a form customers information and i have added a checkbox to the form to make visible these textboxes if additional information is needed for the customer.

question:

how do i make it if a customer needs the checkbox clicked the textboxes will show for only that customer and not all. you see i have an adodc control on the form that gets the information for the other textboxes with access (2000) for the backend. i have put buttons on the form to scroll through the records without using the adodc (which i have made invisible on the form) so when scroll through the records only the ones that have the checkbox checked should show and not all the records i hope i have made sense

I'm using Visual basic 6.0

thanks,
lee123

[Dököll]

i have on a form customers information and i have added a checkbox to the form to make visible these textboxes if additional information is needed for the customer.

question:

how do i make it if a customer needs the checkbox clicked the textboxes will show for only that customer and not all. you see i have an adodc control on the form that gets the information for the other textboxes with access (2000) for the backend. i have put buttons on the form to scroll through the records without using the adodc (which i have made invisible on the form) so when scroll through the records only the ones that have the checkbox checked should show and not all the records i hope i have made sense

I'm using Visual basic 6.0

thanks,
lee123

Hello, lee123!

Just passing through making sure your post is not uinanswered, time zones that whole deal...

Unfortunately, I have a piece of code that queries using the like operator, but the idea is you'd need to add that customer's name to the textbox on the VB form then hit submit, the recordset, ADODC1 recordset, would get filled with only that customer's data, which you can page through.

I am still learning VB, I am not sure how to mastermind this into checkboxes. You let me, I 'll tell you what to do, guide you through.

Anything you have working by the way can be added for a closer by our experts here, may help shed some light:-)

In a bit!

[Dököll]

Hello, lee123!

Just passing through making sure your post is not uinanswered, time zones that whole deal...

Unfortunately, I have a piece of code that queries using the like operator, but the idea is you'd need to add that customer's name to the textbox on the VB form then hit submit, the recordset, ADODC1 recordset, would get filled with only that customer's data, which you can page through.

I am still learning VB, I am not sure how to mastermind this into checkboxes. You let me, I 'll tell you what to do, guide you through.

Anything you have working by the way can be added for a closer by our experts here, may help shed some light:-)

In a bit!

I was thinking lee123, perhaps your checkboxes can act as your submit button, get it. If we add the code under the checkbox and not the submit button, you would in fact be querying for that customer.

I may be way off:-)

[Killer42]

If I'm reading the question correctly, you just want the textboxes to appear or disappear automatically as you scroll through the records, based on the value of a field (which is displayed as a checkbox).

You should be able to do so by coding in the appropriate event procedure on the data control. Not sure exactly which event, though. I seem to recall there are ones which are fired when you move between records, before/after the record is displayed, and so on. I may be getting mixed up with forms in MS Access, though. I do know the built-in data control has a Reposition event.

Another alternative might be to just watch for a change in the value of the checkbox - either by using an event procedure of the control, or a timer.

[lee123]

Hey killer42 & Dokoll:

thanks for getting back with me you two. but killer42 you have hit the nail on the head (sorta speak) i have put a code in the form_load because in access i think you have to do this and put the code in the checkbox also. but i tried in my form (vb) but when i scrolled through the records the checkbox was checked on all and not just the ones i have checked but i'll try this what you have stated. i'll get back with you and tell you if it worked or not.

thanks,
lee123

[lee123]

oh just so you have an idea what i have in the checkbox here it is:

 If Check2.Value Then
        txtVehicle2.Visible = True
        txtVehicle3.Visible = True
        Label21.Visible = True
        Label22.Visible = True
        Label17.Visible = True
        txtHowManyVeh.Visible = True
Else           
        txtVehicle2.Visible = False
        txtVehicle3.Visible = False
        txtHowManyVeh.Visible = False
        Label21.Visible = False
        Label22.Visible = False
        Label17.Visible = False
    End If

Thanks,
lee123

[lotus18]

oh just so you have an idea what i have in the checkbox here it is:

 If Check2.Value Then
        txtVehicle2.Visible = True
        txtVehicle3.Visible = True
        Label21.Visible = True
        Label22.Visible = True
        Label17.Visible = True
        txtHowManyVeh.Visible = True
Else           
        txtVehicle2.Visible = False
        txtVehicle3.Visible = False
        txtHowManyVeh.Visible = False
        Label21.Visible = False
        Label22.Visible = False
        Label17.Visible = False
    End If

Thanks,
lee123

Hey You had forgotten to add value to a checkbox. Minimizing the codes:

Public Sub CheckValue(a As Boolean)
      txtVehicle2.Visible = a
      txtVehicle3.Visible = a
      txtHowManyVeh.Visible = a
      Label21.Visible = a
      Label22.Visible = a
      Label17.Visible = a
End Sub
 
If Check2.Value=1 Then
    CheckValue True
Else
    CheckValue False
End If
 

Rey Sean

[Killer42]

Oh, so we want to minimise code, do we? :) Well, I'll take that challenge.

Without changing your CheckValue sub...

CheckValue (Check2 <> 0)

[Killer42]

lee123, anything you put in the Form_Load event procedure will only be executed once, when the form is loaded. You need to use an event which will occur at the point you are interested in . That is, when you change records.

[daniel aristidou]

lee123, anything you put in the Form_Load event procedure will only be executed once, when the form is loaded. You need to use an event which will occur at the point you are interested in . That is, when you change records.

Could you not use the textbox.textchanaged event on the textbox containing the primary key........ wait im not sure whether that is vb6..,,,