By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

Combobox List

100+
P: 173
Hi,

i have a combobox that lists company names....

selecting the company name automatically populates the address fields (address line 1,2, 3 and postcode)....

in the combobox i have 5 columns, company name, address1, address 2, address 3 and postcode.......

in the Column width, i have 8,0... which only shows the company name ( as i want)...I ONLY WANT TO SHOW THE COMPANY NAME

but theres a scrollbar in the combobox that still takes me to the other columns(address 1, 2, 3 and postcode).. HOW DO I GET RID OF THIS SCROLLBAR???

thanks
Dec 15 '06 #1
Share this Question
Share on Google+
11 Replies


Expert 100+
P: 218
Hi,


Try setting the column widths to zero for those columns you don't want to see

HTH

Steve
Dec 15 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Column Width 8cm ;0cm ;0cm ;0cm ;0cm

Mary

Hi,

i have a combobox that lists company names....

selecting the company name automatically populates the address fields (address line 1,2, 3 and postcode)....

in the combobox i have 5 columns, company name, address1, address 2, address 3 and postcode.......

in the Column width, i have 8,0... which only shows the company name ( as i want)...I ONLY WANT TO SHOW THE COMPANY NAME

but theres a scrollbar in the combobox that still takes me to the other columns(address 1, 2, 3 and postcode).. HOW DO I GET RID OF THIS SCROLLBAR???

thanks
Dec 15 '06 #3

100+
P: 173
cheers mary
Dec 15 '06 #4

100+
P: 173
Thats working now Mary.......

the address fields populate now.........

but the fields cannot be manually edited?? why is that

i want it to populate...(which it is doing) but i want it to be manually accesible.... so if i want to add a new address, i can just write into the fields??

how can i do this?
Dec 15 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Thats working now Mary.......

the address fields populate now.........

but the fields cannot be manually edited?? why is that

i want it to populate...(which it is doing) but i want it to be manually accesible.... so if i want to add a new address, i can just write into the fields??

how can i do this?
You can't with a list.

You will need a subform or popup form to do this.

Mary
Dec 15 '06 #6

100+
P: 173
You can't with a list.

You will need a subform or popup form to do this.

Mary

so will the popup form insert new details into these fields?

do u have any ideas?
Dec 15 '06 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
so will the popup form insert new details into these fields?

do u have any ideas?
If the form has the table as it's record source it will allow you to edit and add records as normal. Then in the On Close event of the form requery the list on the first form.

Expand|Select|Wrap|Line Numbers
  1. [Forms]![FirstFormName]![ListboxName].Requery
Mary
Dec 15 '06 #8

100+
P: 173
this is not clear to me..........

so you suggest that...............

i have an additional button that will take me to a new form where i can input the new address details.......... and this will then update the table fields.............

once that is done, it will show in the list of the combobox??? is that right?
Dec 16 '06 #9

MMcCarthy
Expert Mod 10K+
P: 14,534
this is not clear to me..........

so you suggest that...............

i have an additional button that will take me to a new form where i can input the new address details.......... and this will then update the table fields.............

once that is done, it will show in the list of the combobox??? is that right?
As long as you requery the list yes

Mary
Dec 16 '06 #10

NeoPa
Expert Mod 15k+
P: 31,660
Alternatively, you can populate the list with literal data.
If you set the RowSourceType to "Value List" then you provide a string with all the values included.
This can then be updated in code to add any new items that are required.
If you already have the data stored in your database, though, this would not seem to be a clever way to go unless the additions were always considered temporary or session scoped.
Dec 17 '06 #11

100+
P: 173
i have a form that has the address details plus other details.........

i can select the name of the site and it automatically populates the address fields (and the next step would be to fill in the rest of the form)......

for a new address........ i have a button that takes me to a new form where i can input the new address.....

what im worried about is, if i add the new details to the table from my new address form......it adds and i can select it from the combobox to get it to populate................., but then if i fill in the rest of the form and click the add button, will it add it as a new record?????

i want it to add to the record which has the new address............

do i make sense??:(
Dec 18 '06 #12

Post your reply

Sign in to post your reply or Sign up for a free account.