N
Norm1111
I am having troubles displaying information from a table to one of m
forms. When I change the Combo box the other details do not chang
unless I close the form and re - open it.
I have a table with personal details stored in it and want to put thi
onto a form that keeps track of what keys people have access to.
I want a form to have a key holder’s personal details and a list o
keys. When I change a combo box “EMPLOYEEID” I need the Persona
details to change with it.
EMPLOYEEID is the Primary key.
This is a short representation of the table’s relationships
PERSONAL DETAILS________________KEYREG
-----------------------------------------------------------------
EMPLOYEEID----------------------EMPLOYEEID
FIRSTNAME_______________________KEY1
SURNAME_________________________KEY2
DOB_____________________________KEY3
I have created a query for the KEYREG form and put the following in it
PERSONAL_DETAILS.FIRSTNAME
PERSONAL_DETAILS.SURNAME
PERSONAL_DETAILS.DOB
AND
KEYREG.EMPLOYEEID
KEYREG.KEY1
KEYREG.KEY2
KEYREG.KEY3
I created my form with the wizard and used the query above for it’
data. I then deleted the EMPLOYEEID text box and put in a combo bo
and pointed it to retrieve information from th
PERSONAL_DETAILS.EMPLOYEEID table and told it to save it’s selection i
the KEYREG.EMPLOYEEID. When I change the Value of the combo box I wan
it to change the personal details at the same time.
I did something similar on another form and done all of the previou
steps the same and when I changed the value in the combo box the othe
details changed with the combo selection.
The only difference that I can see when I create this form I get aske
if I would like to use sub-forms or if I would like to put all of th
data onto one form. I did not get this during the other form’
creation. (I chose one form in this instance)
& :mad
forms. When I change the Combo box the other details do not chang
unless I close the form and re - open it.
I have a table with personal details stored in it and want to put thi
onto a form that keeps track of what keys people have access to.
I want a form to have a key holder’s personal details and a list o
keys. When I change a combo box “EMPLOYEEID” I need the Persona
details to change with it.
EMPLOYEEID is the Primary key.
This is a short representation of the table’s relationships
PERSONAL DETAILS________________KEYREG
-----------------------------------------------------------------
EMPLOYEEID----------------------EMPLOYEEID
FIRSTNAME_______________________KEY1
SURNAME_________________________KEY2
DOB_____________________________KEY3
I have created a query for the KEYREG form and put the following in it
PERSONAL_DETAILS.FIRSTNAME
PERSONAL_DETAILS.SURNAME
PERSONAL_DETAILS.DOB
AND
KEYREG.EMPLOYEEID
KEYREG.KEY1
KEYREG.KEY2
KEYREG.KEY3
I created my form with the wizard and used the query above for it’
data. I then deleted the EMPLOYEEID text box and put in a combo bo
and pointed it to retrieve information from th
PERSONAL_DETAILS.EMPLOYEEID table and told it to save it’s selection i
the KEYREG.EMPLOYEEID. When I change the Value of the combo box I wan
it to change the personal details at the same time.
I did something similar on another form and done all of the previou
steps the same and when I changed the value in the combo box the othe
details changed with the combo selection.
The only difference that I can see when I create this form I get aske
if I would like to use sub-forms or if I would like to put all of th
data onto one form. I did not get this during the other form’
creation. (I chose one form in this instance)
& :mad