Forms

[RCBricker]

Someone in the office created a form that i have to use on a regular basis. Not all tht info is the same, but most remains the same. I want him to had an auto fill feature and he won't. SOOOOOO. I want to move this form to Excel or Word and create my own drop downs. IS this possible? Even without access to the system?

 

[Dugantrain]

I'm sorry, but your problem is just about illegible. Try to be a little clearer and cite an example of what you're trying to do and maybe we can help.

 

[RCBricker]

A payment form was created in access. I want a list box made of payees so i do not have to type them each time. The guy who sets that stuff up won't do it. SO i want the exact form in excel so that i can add my own list boxes.

 

[Dugantrain]

Well, I'm not sure about controls in Excel (don't use it as much) but in Access, this should be very easy. You can write a query which captures all of the names (Select Distinct so that each name shows up only once) and then base the List Box's Record Source off of that query. Then, bind the Control Source for the List Box to the field in the table where you'd like this information to go (probably the same field that was your Record Source). Why won't the Access guy do this? If there's a legitimate reason other than laziness or lack of knowledge, surely you'd want to heed his advice?

 

[RCBricker]

he has other things on his plate. Thanks for the answer unfortunately He is the only one that can make changes like that.