Combobox List

14,534

Expert Mod 8TB

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

Beany

173

100+

cheers mary

Dec 15 '06 #4

Beany

173

100+

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

14,534

Expert Mod 8TB

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

Beany

173

100+

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

14,534

Expert Mod 8TB

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

[Forms]![FirstFormName]![ListboxName].Requery

Mary

Dec 15 '06 #8

Beany

173

100+

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

14,534

Expert Mod 8TB

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

32,556

Expert Mod 16PB

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

Beany

173

100+

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

Similar topics

ComboBox Default values

by: NCrum | last post by:

I want to set the Default value of a Combobox for any changeable record and have got this working but it is totaly unsatisfactory see the code below I loop through the items in the Combo looking...

Access 2002 Like Combobox in .NET

by: SKarnis | last post by:

We are trying to rebuild a current Access 2002 (XP) mdb program to VB.NET with a SQL database - we are having problems with a suitable combobox. There are many threads discussing multiple column...

combobox selectedindexchanged event

by: tbrown | last post by:

I have a combobox with items like this: {one,two,three}. The selected index is 0, so "one" appears in the combobox text. When the user drops down the list, and selects "two", for example, I...

Is there an alternative to a combobox for selecting -- VB2005?

by: =?Utf-8?B?UmljaA==?= | last post by:

Greetings, I have to load 30,000 unique names into a combox. Filling a dataTable takes only a few milliseconds. But populating the combobox and displaying the list takes several seconds - way...

Can I make a combobox that is stronly typed?

by: active | last post by:

I'm using a ComboBox to display objects of a class I've defined, say CQQ. Works great except somehow I occasionally set an Item to a String object instead of an object of type CQQ. It looks...

Designer shows combobox but run time does not

by: active | last post by:

I tried to use a datasource with a combobox and it didn't work completely so I build a small test that was much more straight forward then the app. The test was to see if the combobox dropdown...

ComboBox Item (Windows Forms)

by: Jerad Rose | last post by:

I'm baffled by this -- is there not a typed object used for ComboBox Items? Best I can tell, all of the methods for ComboBox that accept an Item are of type Object. Why in the world is a...

.NET Framework

Select Blank values from combobox and find result depend on it

by: billa856 | last post by:

Hi, I have to use the table(PRODUCTION) already generated in MS Access in which all fields are of TEXT type.fields like (orderdate,palletno,customercode,itemno,pono,carto n,pcs,totalquantity)Now i...

Microsoft Access / VBA

Enter null values from ComboBox

by: Andrus | last post by:

I need to enter null value from combobox to business object property. My combobox datasource does not contain ValueMember with null value. So I tried to create combobox which stores null to bound...

Re: Propertygrig again and combobox

by: Marc Gravell | last post by:

Sure; just set the DataSource, DisplayMember and ValueMember of a DataGridViewComboBoxColumn (below ). Marc using System.Collections.Generic; using System.Windows.Forms; using...