X
Xyan
O.K. So I have created a form that has a combo box that
when a user selects a project title from the drop down
list the related ProjectID and ProjectDescription
autofill the text boxes. Then the person will be able to
enter their review data in the rest of the form. The
problem I am having is that by choosing a selection from
the drop down list either a new record is being made in
the Project table OR 1/2 the time the ProjectTitle is
being replaced by an arbitrary # or the other 1/2 the
time the ProjectTitle is being replaced by the ProjectID
#.
So, to make a long story short; is there some way that I
can have a drop down list that will pull up a
record/information from a table without creating a
duplicate record or replacing information in a field?
Sorry if this is something that should be obvious. I
have been puzzling over this for a day or two.
Thank-you in advance for your help,
Xyan
when a user selects a project title from the drop down
list the related ProjectID and ProjectDescription
autofill the text boxes. Then the person will be able to
enter their review data in the rest of the form. The
problem I am having is that by choosing a selection from
the drop down list either a new record is being made in
the Project table OR 1/2 the time the ProjectTitle is
being replaced by an arbitrary # or the other 1/2 the
time the ProjectTitle is being replaced by the ProjectID
#.
So, to make a long story short; is there some way that I
can have a drop down list that will pull up a
record/information from a table without creating a
duplicate record or replacing information in a field?
Sorry if this is something that should be obvious. I
have been puzzling over this for a day or two.
Thank-you in advance for your help,
Xyan