Parse data from one form to another?

[ADRIAN]

Hi there,

I've been banging my head on the desk over this one for a few days now
so thought I'd mail out and see if anyone had any ideas!

I need a list of names in a ListBox (it's called list6 for the want of
a better name!). I need the ability to add names to this list at the
click of a button.

For example, press a button which brings up another form with dropdown
list of names, select a name - press ok, and this information would
now be in "list6"

Hope this makes sense, and moreover hope that someone may have a
suggestion or several!!

Thanks in advance,

Adrian

 

[Guest]

Adrain,
You have the right idea. If you have a pop up form with the lookup table
data you can attach the opening of that to a button on your main form. Then,
you enter the new data on your pop up form.
To get the new data on your original drop down box, you put
DoCmd.Requery "list6" on the On Got Focus event which will update the drop
down box with the new data.

Do you need to have the new record added on the pop up form be added to the
field on your original form?

 

[adrian]

Hi there,

Thanks for getting back to me! I'll try to explain some more what I
need to happen:

Have one form with one list of names (in a list box) List6
One cmd button to launch a new smaller form CMD8
On this smaller form a Combo of names (not the same as list6) NameCombo
Also a button, CMDOK

Basically, I need press CMD8, select a new name from NameCombo and
press CMDOK to add this name to List6 ~ Does this make any sense? It's
starting to not make much sense in my head

Thanks again

AJN