Search results

Hi Kiwi, I managed to get it working but did it slightly dif. I didnt bother with a Form event, I just used combo event "On Change" And entered this code (pretty much them same really) Private Sub callcount_Change() Select Case Me.callcount Case Is = 1 textboxa.Visible = True...

Hi Kiwiman, Thanks for your help with this, need a little more with the code you gave me please. I put an Event Procedure in the 'On Current' on the form and put the code: Private Sub Form_Current() Select Case Me.callcount Case Is = 1 textboxa.Visible = True textboxb.Visible = False...

Hi can someone please help me out here. I would like to hide or display 3 text boxes based on a value in 1 combo. Lets say the values in the combo are 1;2;3 And I have three text boxes called a, b and c If I select 1 in the combo box I would only like text box a to be diplayed. If I select 2...

I see my mistake now doh! Thank you again Kiwiman. I finally got there. Cheers Dino

Thanks for the reply again. I took your advice and removed the spaces from the table name and fields. I then inserted a combo box via the wizard to get the simple list of agents, which is fine. When I then try tag the rest of the code on, I get another error message: "The number of columns in...

Hi Kiwiman, Thaks for the fast reply (again). I tried to put your the same criteria as you have but keep getting an error "Syntax error (missing operator) in query expression 'tblAgent Details. Notes Name" I have the following in my row source: SELECT tblAgent Details.Notes Name, tblAgent...

Can anyway point me in the right direction?? I have a combo box controlled by a table, the table has various columns within it. One is Employee name, I am using a combo box listing the employee names on a form which controls filtering for a report. Its fine if I or another user wants to select...

Thanks for the fast reply. Now that you put the answer it all becomes clear, think I was having a silly off day. Many Thanks for you help.

Hi There, Can anyone help me with this query I have please: I have a table in that contains employee names with various other employee details, one other detail is a tick box that indicates if the employee is still with the company or not. I then have a form with a combo box to which links...