APPEAR AND CHANGE RECORDS IN A FORM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have a form which appear the fields of a table. Until this it
os i ve already done. The problem is when i insert tke primary key. I want
when i type the primary key on the form to see the rest of data which
correspond to this key appear on the form. For example if in table i have tis
record: "181" "Andreas M" "Good boy", where the 181 is the primary key and
then in the form I insert the primary key (181) i can see in the other fields
"Andreas M" and "Good boy". How I do that?
Thanks for your time
 
I would suggest that entering the primary key is not the best way. How will
the users know the primary key? Do they need to look it up before they
begin? I think a better choice is to use the combo box wizard to "Find a
record on my form based on the value I selected in my combo box". Follow the
prompts to have the person's name appear, and to "Hide the key column". If
you still want the users to select the primary key instead of the name you
can do that by not hiding the key column, then in the combo box properties
set the column count to 1 and make sure the column width is greater than 0.
 
tHE DATABSE IS a aplication-exercise for my univercity and the teachers
already will have the key, and in the other fields the teachers will write
the degree of the exam of the students. So dont confused you. I try to make a
combo box and i choose "Find a record on my form based on the value I
selected in my combo box with primary " from wizard but i have problem when i
try to choose a record because i take the message "Module not found " What
can i do?
 
What is the row source for the combo box? If it is a SQL statement you
should be able to look at it in Datasheet view. Does it have the same
information that you want to see in the combo box?
 
Try making a query based on the table. Use that query as the source when you
use the combo box wizard. Do not hide the key column, since you are
selecting the primary key.
 
Back
Top