Data to Pop up

[Quiggle]

Hi all,

Im afriad Im a semi Access Virgin. I used it at college and then haven't again for about 4 years and can't remember alot.

I am making a database and I have completed most of it, im now stuck.

What I want to do is make some data which can't be changed pop up in another text box!! What I have at the moment is a combo box which is a multi column lookup, and I just want the information from the other two columns to appear in two text boxes next to the option which is picked.

i.e. I have a list of Names, Location and phone numbers, which can all be seen in the combo list, but once one has been selected you can only see the Name and I want the Location and Phone number to be visible as well next to it.

I beat people are asking this kinda thing all of the time and Im REALLY SORRY!!

Can't anyone help me?

Thanks

Quiggle

 

[MStef]

Check and adjust COMBO BOX PROPERTIES:
Column Count
Column Widths
List Width

 

[Quiggle]

That will just vary what information can be seen from the drop down,

I want to use the data from the list and put it in boxes next to the option picked.

You know if you pick an option like name and the database has ur address and phone number, those just pop up next to it and that what i want to happern.

thanks

 

[edtab]

Me.textboxname = Me.comoboxname.column(0)
if you want to capture the value of field no. 1 of
your combobox. You can adjust the code accordingly
depending on which column you want to capture.

Combobox indexes start with a base of 0, so column(0)
is actually field no. 1 in your dropdown.

 

[Quiggle]

Thanks edtab.

Sorry for being such a virgin,

Where abouts do I put this code?
And
Is the me = form name?

Thanks

Quiggle

 

[Joebax]

Me is a special shortcut so that you do not have to type in the name of the form.

I would put the code in the after_update event of the combo box.

 

[Quiggle]

I tried that and got this error message:-

(see attachement)

What do I need to put in the Macro? Ive never used a macro before part from for simple buttons and can't really remember what im doing with them. Do I need to create one called 'me' to solve this error?

Thanks for all of your help

Quiggle

 

[Quiggle]

The error occurs when i enter data into the field with the combobox, as soon as i have entered the data and tabbed across the error pops up, you can continue to type etc, but also nothing appears in the other text box.

Thanks

Quiggle