Jed
|
| Posted: 04/15/2002, 6:33 AM |
|
I have created a website with codecharge. Yet I am having many problems with it. I am trying to link a lookup box to a given record. For example in u click on the lookup box an it enters that update directly in to the searchable record.
Check my site: http://www.withs.org/lehman
P.S. I dont know much.
|
|
|
 |
Jed
|
| Posted: 04/15/2002, 6:44 AM |
|
Put in ID 1919 for an example.
Thanks
P.S. I am a complete idiot
|
|
|
|
Nicole
|
| Posted: 04/15/2002, 6:51 AM |
|
Jed,
please elaborate a little. Do you mean that right after selecting any value from any listbox on Form2 the selected value appeared in ID field of Enter ID# form?
|
|
|
|
Jed
|
| Posted: 04/15/2002, 6:59 AM |
|
I would like the entry from the lookup box to relate to the same period listed above, and change the code next to that period. I hope that makes sense =/
Thanx, Jed
|
|
|
|
Nicole
|
| Posted: 04/15/2002, 7:21 AM |
|
Jed,
hm.. update about nine records after submitting the form. The most simple solution is to build and execute nine (or more or less, depends on number of records) update queries and update them with selected values.
May be it could be done in a loop, but details depend on tables structure and variable names for fields.
|
|
|
|
Jed
|
| Posted: 04/15/2002, 8:07 AM |
|
Hello Again Nicole =)
So you are thinking that i should make update queries? Would that be done in MS Access? I really do not know where to begin, and i am sorry. Could you possibly walk me through it or direct me to another place where i can learn more information on update queries?
Thanx So Much Nicole
TTYL 
|
|
|
|
