Re: List Item (drop down menu) problems...please help - searchform.jpg (0/1)

Hope my suggestions help. If you need any further help post a message on the newsgroup, I check it most days.

Good luck with the form.

Regards,
Vanessa.

"Maarten Martens" <maarten.martens_at_freebel.net> wrote in message news:jblu6tkjjelpgglqvkfrjpsepga7jd3la9_at_4ax.com...
> Thanx for the advice Vanessa...I'm gonna give this a shot...May I contact
 you by
> email if I'm experiencing other problems?
>
> Sincerely,
> Maarten
>
> >Hi Maarten,
> >
> >What you need to do is set the update and insert properties of the block
 to
> >false (to prevent records being altered or inserted).
> >
> >You should add a trigger at form level WHEN-NEW-FORM-INSTANCE which has
 the
> >command 'enter_query;'. This will put the form into enter query mode
> >everytime the form is opened.
> >
> >The user can then select a student name from the pull down item and then
> >press F8 to execute query.
> >
> >Once the record has been retrieved the user will have to press F8 to
 clear
> >the form and put it back into enter query mode, or you could place the
 form
> >in enter query mode by placing a trigger on a button, that is a
> >WHEN-BUTTON-PRESSED trigger on a button with the command 'enter_query;'.
> >
> >I hope this helps.
> >
> >Vanessa.
> >
> >"Maarten Martens" <maarten.martens_at_freebel.net> wrote in message
> >news:tj7u6t0tulo66johj8gr9luiutop1fqsua_at_4ax.com...
> >> Hello,
> >>
> >> I'm a beginner in oracle and have a question. I'm working on this
 little
> >> project...
> >>
> >> Is it possible when running a form to switch it automaticaly into
 "enter
 query
> >> mode" (without pressing F7) so that the data of the DB couldn't get
 altered? I
> >> included a little jpg, to give you people an idea. What I would like to
 do
 is
> >> when I run this form, and choose a student name from the drop down item
 (search
> >> student), all the other fields are filled automaticaly with the correct
 data
> >> from the tables of my DB...But without changing any records on DB level
 (only on
> >> form level). Is this possible? How?
> >>
> >> I hope any of this makes sense to you people...
> >>
> >> Are there any good oracle sites on the net? With info on list items and
 field
> >> connections and so on...
> >>
> >> Thanx in advance
> >> Maarten
> >>
> >
>
Received on Thu Jan 25 2001 - 21:39:57 CET