Search results

thanks so far, zigzag, Text20 doesnt show anything when i select a user from the combobox? (it does work by selecting it on the subform) Text18 doesnt display any info but i have an error #Name??

Hi sorry Zigzag, was going to try it later.. looking at your attachment Text20 and Text18 in AssetMain displays nothing when i select a user from the comboboxes??? sorry to be a pain

ajetrumpet, thanks for your input... Ok sorry for any confusion, I kinda admit my forms a bit all over the joint :o Let me explain, I want to make a selection from one of the comboboxes Filter by User, Filter by Department or Filter by Location so it shows the associated items in the...

Thanks Zigzag for your response: But I couldnt get both of the codes to work: On Click: Code: Forms![AssetMain]![Text20] = txtCountUser For the second part of your question, Put this into the Control Source of Text18 Code: =Asset_subform.Form.Recordset.RecordCount

when i open the textbox TEXT20 i get the following info Wayne Rooney Site Essex.. the first person in the subform list... strange?? Sorry mate, but what i mean by this is, if i select a user from the comboboxes it displays the items in the subform below...eg so if a user had 6 things...

Hi, Looking at my attached database, firstly when i load the form 'AssetMain' i would like the textbox Text20 to be empty until i select someone from the subform or from the comboboxes???? When this form is loaded textbox Text20 automatically has info in it.. Secondly, textbox Text18 should...

anyone? im really stuck

okay ive tried this now, ive put the textbox over the two combos.. it enables them but i cant see the comboboxes..just a white empty space with a blinker.?? I am pretty sure that everything is transparent... and how do i get rid of the blinker? thanks

it seems like a good idea, i understand all the way to the bit of placing an unbound text box with a transparent border and background over the two combo boxes.. but what code am i going to use for the dbl_click event? is it the .enabled=false?

is there another way of doing this? instead of using .enabled=false??

What i want to do is, if i select one combobox then i want the other two to dim/fade out. But then if i click on the dimmed/faded combo then it should get rid of the dim/fade. does that make sense :)

Hi, i have three comboboxes, if i select one the other two are disabled. I am using the code: combo2.enabled = False. The problem is then i cant select the other two comboboxes after this.. is there a way when the other two comboboxes are disabled, i can enable them if i put my cursor over...

Velosai, its working... thank you

ive got the following in my control for location: =User.Column(2)

Velosai and Rich -----------> thank you User combo now populates Department but for some reason it will not populate my location textbox... why is that? ive checked all steps you told me to carry out..

Dennisk, i understand mate, youve been excellent help mate.. Is there anyone that can have a look at my database? please thanks

your info is so correct but when im working with it, it aint gona work... :( ive attached my database, it would be nice of you to have a look and see what im doing wrong... thanks

do you have an example i can look at? for some reason i cant get it to work... im relatively new to access.. thanks

ive got a subform, and within the subform i have three comboboxes, user, department and location. how do i get info into the fields department and location when i select a user from User combobox (in subform)? data can be extracted from the tblUser.

Hi, Possibly a simple question.. I have a table called User with fields: User, Department and Location.. In a subform, i have the same three fields.. in the subform, i would like to select a user from the user field and it automatically populates the department and location fields (info from...