Search results

Indeed, the name of the textbox is txt_pi It didn't work, mabye because I'm not using the textbox to input values but rather to display a result from a selection my the combo's; In the last combo I use: txt_pi = Me.cbo_pg.Column(2) in the afterupdate event.... So maybe I need something like...

Thanks alot, will try first thing in the morning :)

I guess what I'm looking for is something like: If txt_pi.Value = "FORBIDDEN" Then txt_pi.ForeColor = vbRed but that doesn't seem to work..

Is it also possible to change the color of the font depending on the text displayed in the textbox?..

Love this forum, solved another one :)

You are absolutely right.. I will have a look at it tonight, thanks.. Have been thinking to add a table for those questions/checkboxes but as this is just a very basic version that I have in mind and my time is rather limited I didn't yet. I don't even know the questions yet so can't really...

little mistake.. solved it like: If Me.chk_reject = False Then DoCmd.Requery "chk1" [chk1] = False If Me.chk_reject = False Then DoCmd.Requery "chk2" [chk2] = False etc..

I did, but now I want to make it where I can erase chk1 to chk30 when I manually uncheck chk_rejected. I mean I can do this with If me.chk_rejected = False Then chk1 = False And chk2 = false etc.. It will work and I will do this in the mean time but it might be bit sloppy (?) Really want to...

Thanks alot... Btw, the other way around is gonna be even worse: Would like to uncheck chk_reject when all 30 boxes are unchecked and came up with this in the afterupdate of chk1 to chk30: If chk1 = False And chk2 = False And chk3 = False And chk4 = False And chk5 = False And chk6 = False...

Figured it out so might as wel post it in here for people that are looking for the same thing.. In the afterupdate event of the checkboxes insert: If Me.chk1 = -1 Then chk_reject = True

Thanks, I'm very new to this VB stuff but I think I'll be able to figure it out then :D

In my form I have 30 checkboxes named chk1 to chk30, whenever I check one of these checkboxes I would like chk_reject to be checked as well. Is there a way to do this without editing the afterupdate of 30 checkboxes?

this is giving me a mild headache, I'm so close yet I can't figure it out... :confused:

I attached my form, can someone please help me with this?

I tried this but then my combo3 stays empty... help :(

This method doesn't work on combos though, is this possible for combos as well?

Thanks thanks thanks! *2 thumbs up* Finally my little project is going somewhere :D

I'll try that this evening... many thanks in advance...

Does anybody know if it is possible to let the cursor jump to the first character in a textbox and combobox when you select these controls with the mouse?

But in the 2nd combo I select 2 values; un and psn... how do i make the 3rd combo know it must also query the 2nd column (psn) of the selection made in the 2nd combo? Right now I display the 2nd column (psn) in a textbox by adding this in the afterupdate: txt_psn = cbo_un.Column(2) Then I...