M
Mike Green
Hi all
Here is my dilemma
I am trying to create a form that the user can select a category and either
type in a free text description in the next cell of a continuous form or on
selecting certain categories they will have a pre defined pick list that the
user must select a single item from a list presented to populate the next
cell.
I have got to this so far:-
I have a Continuous form with a drop down box to allow the user to select
the required category. What I am looking at doing is depending on the
category selected there are two outcomes either the category is selected and
the user continues on to the next field in the form (FdDescription) or (this
is the bit I am stuck on) another form is launched displaying a list of
items that belong to the previously selected category. On double clicking
on of the items in the list I want the item selected to be transferred to
the FdDescription (just like copy and paste but to do it with code)
A few of the 'problems/questions' that I have
1. Is this the best way to do it? If not can someone give me some
pointers?
2. How do I code the solution to ensure that when the form containing the
list has an item selected (I was using DblClick) the information is passed
back to the correct row and cell of the form that launched it?
Regards
Mike
Here is my dilemma
I am trying to create a form that the user can select a category and either
type in a free text description in the next cell of a continuous form or on
selecting certain categories they will have a pre defined pick list that the
user must select a single item from a list presented to populate the next
cell.
I have got to this so far:-
I have a Continuous form with a drop down box to allow the user to select
the required category. What I am looking at doing is depending on the
category selected there are two outcomes either the category is selected and
the user continues on to the next field in the form (FdDescription) or (this
is the bit I am stuck on) another form is launched displaying a list of
items that belong to the previously selected category. On double clicking
on of the items in the list I want the item selected to be transferred to
the FdDescription (just like copy and paste but to do it with code)
A few of the 'problems/questions' that I have
1. Is this the best way to do it? If not can someone give me some
pointers?
2. How do I code the solution to ensure that when the form containing the
list has an item selected (I was using DblClick) the information is passed
back to the correct row and cell of the form that launched it?
Regards
Mike